Female only diagram?

Dagwood · Post by **Dagwood** » 31 Oct 2011 19:57

Having become intested in the female DNA (see Research forum post)I wondered if it is at all possible to show a maternal ancestor diagram. Any suggestions most welcome.
Dagwood

ID:5536

Post by **tatewise** » 31 Oct 2011 20:29

One approach would be to write an Individual Query that lists all individuals with a particular gender.
e.g. Row Filter: Add if %INDI.SEX% matches ['Gender']
Use the Ancestor Diagram option Marks > Set/Clear Marks using Query and Select marked boxes.
You may have to deselect the Diagram Root.
Finally use Hide Selected Boxes.
By choosing the gender in the Query you can obtain either Male only or Female only ancestors.

Dagwood · Post by **Dagwood** » 31 Oct 2011 22:05

Thanks Mike, I'll give that a try.
Dagwood

YouTube · Post by **Jane** » 01 Nov 2011 08:44

If you search in the Downloads for Female you will find a couple of queries which already do this.

Dagwood · Post by **Dagwood** » 01 Nov 2011 20:41

Thanks JJane, they work perfectly. Is it possible though to work the other way round and select a female and list her ancestors? The cream would be on the cake if so and especially if I could then create a diagram from the list. Is this possible?
Thanks
Dagwood

Post by **tatewise** » 02 Nov 2011 11:00

Yes, in the Query update each Rows filter Relationship to Ancestor.

To create the Diagram, first use the Query Menu option to Run and Invert Result Set and Add Result Set Records to Named List.
Then use the technique I described earlier to Mark, Select, and Hide boxes in your Ancestor Diagram.
But use the Standard Query called Named List Members and select the Named List where you saved the Inverted Result Set.

P.S. You may find it simpler to use the idea I suggested using a Gender Query.

Dagwood · Post by **Dagwood** » 02 Nov 2011 14:46

Thanks Mike , I won't get a chance to try either way before I get back home on Tuesday but will give it a go then. I've never played around with Queries before other than to run a standard one, so it will be interesting to see whether it works after I've fiddled with it.
Dagwood

Post by **tatewise** » 02 Nov 2011 15:46

You may find the Knowledge Base article on Creating a Query useful.
http://www.fhug.org.uk/wiki/doku.php?id ... ng_a_query

jsphillips · Post by **jsphillips** » 05 Nov 2011 10:32

Would it not be poosible for Tatewise who is most proficient at queries to write this query please and addit to the down load query list. I also would like to use this query and am not adept at writing them !!
Heres hoping
Thanks
John

Post by **tatewise** » 05 Nov 2011 10:47

Which Query are you after John?
The Knowledge Base > FHUG Downloads ~ Family Relationships section already has Descendant Queries:
1) Female Lines with Generation Numbers at
http://www.fhug.org.uk/wiki/doku.php?id ... on_numbers
2) Male Lines at
http://www.fhug.org.uk/wiki/doku.php?id ... male_lines

These can easily be adapted as described above to work as Ancestor Queries.
The Gender Query is also fairly straightforward.
Try cutting your teeth on these yourself by following the advice in the Knowledge Base article on Creating a Query at
http://www.fhug.org.uk/wiki/doku.php?id ... ng_a_query
Once you have gained that experience then FH offers so much more.

jsphillips · Post by **jsphillips** » 07 Nov 2011 16:21

The query reply you are helping dagwood with

jsphillips · Post by **jsphillips** » 07 Nov 2011 16:22

The maternal ancestor prog with Dagwood
Thanks
John

Post by **tatewise** » 08 Nov 2011 09:39

OK John, this is what you do, it's straight-forward and you'll learn a little about Queries.

From the Knowledge Base > FHUG Downloads ~ Family Relationships section download & import Female Lines with Generation Numbers (Female_Lines2.fhq):
http://www.fhug.org.uk/wiki/doku.php?id ... on_numbers
Run this Query to see how it operates.
Use the Query Menu (icon like a menu with red tick furthest right of the Query name).
Select Save As Custom Query and name it say Female_Ancestors.

On the General tab, in Description and Title, change descendants to ancestors.

On the Columns tab, select the 2nd Heading named Generation.
At the bottom in the Expression change Root Mother to Root Female.
Change Sort from Ascending to Descending, and click Update button bottom right.

On the Rows tab, select the 1st Filter at the top starting with Add if descendant....
At the bottom change Relationship from Descendant to Ancestor and the Label lower right from Root Mother to Root Female, and click Update.
Next select the 3rd Filter at the top starting with Add if descendant....
Change Relationship from Descendant to Ancestor and click Update.
Repeat this last step for 5th to 23rd Filter starting with Add if descendant....

Run the Query and select the Root Female and it will list her female Ancestors.

Dagwood · Post by **Dagwood** » 08 Nov 2011 15:33

I need to learn more about queries so now I'm home I'll have a bash at your instructions Mike and thanks for all your guidance.
In case it makes it easier for anyone who does not want to try the query route can I suggest something I tried while away and that is to creat the Ancestor diagram from whichever Root you choose and then select the Roots father (or mother if you are looking at a paternal line) and after right clicking choose Hide.Repeat this up the tree to eliminate all male ancestors. With my wife's tree of 14 generations it only took a couple of minutes to get the entire maternal line and then save the diagram for future reference e.g.in my case 'Mrs Dagwood's mitochondrial ancestry'
This may not be what everyone needs but it was a quick and easy way to get what I needed.
Dagwood

jsphillips · Post by **jsphillips** » 10 Nov 2011 15:11

Thank you tatewise for your very informative help in this female query write.
Wonderful
Thanks again
John

Dagwood · Post by **Dagwood** » 10 Nov 2011 18:01

Partial Success!
Hi Mike, I've worked thro' your instructions ( and very clear they were too) but I am now showing the root female (0) her daughter (1) and grandchild (2),the root's sister (0) and the sister's children (1) also. The children and g'children are shown with positive generation numbers and all ancestors with negative. The root's mother (-1) is shown along with her sisters(-1) but thereafter just the direct female ancestors
I wondered also why the instructions jumped from line 3 to line 5 and where 'Repeat this last step for 5th to 23rd Filter' comes in, inasmuch as my list showed only 12 lines? Is the 23 part of the instructions elsewhere and I need to change something else?
Finally, and apologies for being a nuisance, but can the resulting list be converted into a diagram which is where we started or is my quick and easy method mentioned earlier the only way of getting there?
Many thanks for your help
Dagwood
ps Before sending this I went back into the Query and changed rows 2 and 4 to Ancestor and got the Root only and Ancestors without any Descendents,siblings or sister. Looks like that was all it needed. I'm still puzzled by the line 23 req't though?

Post by **tatewise** » 10 Nov 2011 20:29

The 1st Row Filter originally was:
Add if a descendant [max.1 generations] of ['Root Mother']. Include original individual.
The 2nd Row Filter was and still is:
Exclude if %INDI.SEX% matches Male
The 3rd Row Filter originally was:
Add if a descendant [max.1 generations] of anyone in the current result set.
The 4th Row Filter was and still is:
Exclude if %INDI.SEX% matches Male
The Row Filters continue alternating odd numbers starting Add if a descendant... and even numbers starting Exclude if....
It is all the odd numbered Row Filters that need changing from descendant to ancestor.

To create a Diagram from this Query you need to follow the directions I posted on 11/02/11 at 11:00:49 above.
But as I said there, it may be easier to use the Gender Query that I posted on 31/10/11 at 20:29:28 above.

Dagwood · Post by **Dagwood** » 22 Nov 2011 17:41

tatewise said:
The 1st Row Filter originally was:
Add if a descendant [max.1 generations] of ['Root Mother']. Include original individual.
The 2nd Row Filter was and still is:
Exclude if %INDI.SEX% matches Male
The 3rd Row Filter originally was:
Add if a descendant [max.1 generations] of anyone in the current result set.
The 4th Row Filter was and still is:
Exclude if %INDI.SEX% matches Male
The Row Filters continue alternating odd numbers starting Add if a descendant... and even numbers starting Exclude if....
It is all the odd numbered Row Filters that need changing from descendant to ancestor.

To create a Diagram from this Query you need to follow the directions I posted on 11/02/11 at 11:00:49 above.
But as I said there, it may be easier to use the Gender Query that I posted on 31/10/11 at 20:29:28 above.

Hi Mike, I went back throught those lines ( 2,4,6 etc ) and altered them back to how you suggested but got the same result as before ie each female ancestor shows her sisters also. Not sure what I'm doing, but it is odd that the wrong way appears to give the result I wanted ie a direct female ancestor line rather than a list of female descendants.
Dagwood

Post by **tatewise** » 23 Nov 2011 11:06

I am a bit confused when you refer to 'lines ( 2,4,6 etc )' when it is lines 1,3,5,7,etc that should be changed.
Do these lines all include the word ancestor or the word descendant?
The Root Female you choose should be the person whose ancestral line you want.
Perhaps try starting from the downloaded Query and follow my instructions again to create a copy of the Query and edit it.
Alternatively, perhaps you could post a screenshot of the Row Filters window.

Dagwood · Post by **Dagwood** » 23 Nov 2011 16:54

tatewise said:
I am a bit confused when you refer to 'lines ( 2,4,6 etc )' when it is lines 1,3,5,7,etc that should be changed.
Do these lines all include the word ancestor or the word descendant?
The Root Female you choose should be the person whose ancestral line you want.
Perhaps try starting from the downloaded Query and follow my instructions again to create a copy of the Query and edit it.
Alternatively, perhaps you could post a screenshot of the Row Filters window.

Hi Mike, Thanks for your reply.
As soon as I get a chance I'll post a screen shot however it is the oddd nos I had changed to Ancestor as instructed but as my post of 10/1/11 said it was only when I changed the even lines also that I got the ancestral line required ie the root person and her female ancestors. When the even lines were as you said in your reply of 10/11/11 I got a result where not only the female ancestors were shown but each ancestors sisters.
I've done as you suggest and run the query again and made all the changes you suggested but don't get the result you say I'll get. I know I'm doing something wrong but can't see what - but then something tells me if I get the ancestral line ( which will be the mitochondrial DNA path required) by doing something wrong I should stick with it.
I fear I'm taking up too much of your time so will get back when I can spend a bit more time later this week and hopefully will have sorted it out.
Thanks for your patience
Dagwood [confused]

Family Historian User Group