Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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