I am trying to maybe set a flag on all the people in a diagram who I cant find in a census. I think I should make a query on this if it can be done, but please can some kind person talk me through this as I am learning all you can do with Family Historian but am struggling with making a new query.
I would be very grateful if someone could help me with this.
Thank you
[confused]
ID:4281
* Flags
Flags
Hi Marilyn,
I'd be happy to talk through doing a query.
1. Open up the standard query called 'Age at Marriage (all),
2. Using the Query Menu (top right with red tick) select 'save as custom query' and give it a name such as 'Census reqd 1901',
3. On the Columns Tab, then the columns box, Select the 2nd & 3rd lines (age @2nd & 3rd marriages) & delete each.
4. Select 'Age At First Marriage' and change the heading to 'Age'.
5. Change the Expression line to '=EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2)'. Change Sort to 'Ascending' then click 'Update'.
6. Click in a blank area of the columns box (to clear the heading etc boxes, then enter 'Date' in the Heading box and '%INDI.CENS[year=1901].DATE%' in the Expression box (this assumes that you use Gedcom Census to enter Census dates), then click 'Add'.
7. Now select the Rows Tab.
8. Delete the filter that is there.
9. Build a new filter with Condition being 'exclude If',
10. enter '=EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2)' in the expression box ,
11. Change the operator to 'is less than' and enter '1' for the value. Then click 'Add'.
12. copy 9. & 10. but this time make the operator 'is greater than' and 100 for the value.
13. Return to the Columns Tab and copy the expression from date line (%INDI.CENS[year=1901].DATE%). Return to the Rows Tab and create a new filter and enter the copied expression into the expression line.
14. Change the condition to 'exclude if' & operator to 'equals' & value to '31 March 1901'.
- So far this creates a query that shows those people whose estimated age on the day of the Census was between 0 and 100 AND who did not have a Census date for 1901 assigned to them by Gedcom Census. The results should be sorted in order of youngest first (since I have found that these are the easiest to find on the Census.
You could add other columns as required - I would suggest Birth Place as being the most worthwhile.
Hope this helps
Bilko.
I'd be happy to talk through doing a query.
1. Open up the standard query called 'Age at Marriage (all),
2. Using the Query Menu (top right with red tick) select 'save as custom query' and give it a name such as 'Census reqd 1901',
3. On the Columns Tab, then the columns box, Select the 2nd & 3rd lines (age @2nd & 3rd marriages) & delete each.
4. Select 'Age At First Marriage' and change the heading to 'Age'.
5. Change the Expression line to '=EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2)'. Change Sort to 'Ascending' then click 'Update'.
6. Click in a blank area of the columns box (to clear the heading etc boxes, then enter 'Date' in the Heading box and '%INDI.CENS[year=1901].DATE%' in the Expression box (this assumes that you use Gedcom Census to enter Census dates), then click 'Add'.
7. Now select the Rows Tab.
8. Delete the filter that is there.
9. Build a new filter with Condition being 'exclude If',
10. enter '=EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2)' in the expression box ,
11. Change the operator to 'is less than' and enter '1' for the value. Then click 'Add'.
12. copy 9. & 10. but this time make the operator 'is greater than' and 100 for the value.
13. Return to the Columns Tab and copy the expression from date line (%INDI.CENS[year=1901].DATE%). Return to the Rows Tab and create a new filter and enter the copied expression into the expression line.
14. Change the condition to 'exclude if' & operator to 'equals' & value to '31 March 1901'.
- So far this creates a query that shows those people whose estimated age on the day of the Census was between 0 and 100 AND who did not have a Census date for 1901 assigned to them by Gedcom Census. The results should be sorted in order of youngest first (since I have found that these are the easiest to find on the Census.
You could add other columns as required - I would suggest Birth Place as being the most worthwhile.
Hope this helps
Bilko.
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Flags
Of course, if you are on V4, you could condition the icon directly using an expression by computing if the person is alive at the census, but has no census record.
There's a challenge for you Bilko, get the result in a single expression .[grin] [smile]
There's a challenge for you Bilko, get the result in a single expression .[grin] [smile]
Flags
Hi Jane & Marilyn,
I accept the challenge of writing a diagram expression [rolleyes]- I spent an hour or so on this last night but was unable to get more than 1 part of the expression before I got the 'Not valid' message.[oops]
Marilyn - I apologise I did forget something with my query explanation above - the EstimatedAgeAT function ignores the fact that someone may be deceased! It would be necessary to add another line to check for this. If you want help on this point, please ask, but one of my favourite parts of Family Historian is trying to work out how to achieve something with queries etc (thus why I like the challenge Jane has given me!).
Please check the query expression that you are trying to enter & do not include any quotation marks at the start or end of the expression. IE '=EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2)' is WRONG, but =EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2) is correct.
If your problem is with entering an expression into a diagram, then I have the same problem . . . . [cry][oops]
Have fun
Bilko [smile]
I accept the challenge of writing a diagram expression [rolleyes]- I spent an hour or so on this last night but was unable to get more than 1 part of the expression before I got the 'Not valid' message.[oops]
Marilyn - I apologise I did forget something with my query explanation above - the EstimatedAgeAT function ignores the fact that someone may be deceased! It would be necessary to add another line to check for this. If you want help on this point, please ask, but one of my favourite parts of Family Historian is trying to work out how to achieve something with queries etc (thus why I like the challenge Jane has given me!).
Please check the query expression that you are trying to enter & do not include any quotation marks at the start or end of the expression. IE '=EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2)' is WRONG, but =EstimatedAgeAt(%INDI%,Date(1901,0,0),AVG,2) is correct.
If your problem is with entering an expression into a diagram, then I have the same problem . . . . [cry][oops]
Have fun
Bilko [smile]
Flags
Thanks for all your help Bilko but I am getting totally confused with the whole query business. I have decided to give it a rest for a while, then maybe it will get easier and come to me in a flash. I will revert back to your instructions in a week or so. Thanks again
Marilyn
[confused]
Marilyn
[confused]
-
Jane
- Site Admin
- Posts: 8441
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Flags
Ok, with a bit of work and asking the oracle
Code: Select all
=IsTrue(IsEmpty(%INDI.CENS[year=1901]%)
and IsTrue(EstimatedAgeAt(,DateAt(1901,0,0),AVG,2) < 100)
and IsTrue(EstimatedAgeAt(,DateAt(1901,0,0),AVG,2) > 0))