Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create hierarchy chart

Hello,

I have hierarchy variable:

Europe

Africa

Asia

Europe#England

Europe#England#London

Europe#England#Manchester

Europe#England#Liverpool

Africa#Egypt

Africa#Egypt#Cairo

Asia#China


I want to create a pie chart that contains the first child (for ex. England - 4, Egypt - 2 and China - 1)

something like this:


table.png


How can i do that?


Thank you!

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

Use Calculated Dimension

Then Expression

=COUNT(TextBetween(data&'#','#','#'))

Script :

load * inline

[

data

Europe

Africa

Asia

Europe#England

Europe#England#London

Europe#England#Manchester

Europe#England#Liverpool

Africa#Egypt

Africa#Egypt#Cairo

Asia#China

]

View solution in original post

3 Replies
robert_mika
Master III
Master III

Use Calculated Dimension

Then Expression

=COUNT(TextBetween(data&'#','#','#'))

Script :

load * inline

[

data

Europe

Africa

Asia

Europe#England

Europe#England#London

Europe#England#Manchester

Europe#England#Liverpool

Africa#Egypt

Africa#Egypt#Cairo

Asia#China

]

Not applicable
Author

Thanks a lot! It was very helpful.

robert_mika
Master III
Master III

You are welcome.

Thanks for feedback