Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Saiteja1
Contributor III
Contributor III

Hierarchy

Hi, 

I need the hierarchy like world -> country-> district like a tree format  as in the attached screenshot using pivot table in qliksense or else please suggest me any other way to view like below screenshot

Thank you 

4 Replies
abhijitnalekar
Specialist II
Specialist II

HI @Saiteja1 ,

 

Can you please share the dimensions used in the pivot table, as I can see from the screenshot there is one more level.

or you can share the sample data.

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
Saiteja1
Contributor III
Contributor III
Author

Hi Abhijit

 

Thanks for reply

I didn't have any other data I have only that screen shot 

Dimensions 

world -> country-> district

Please take screenshot as example 

And suggest me the way that I can create

abhijitnalekar
Specialist II
Specialist II

Please try unchecking this check box for the dimensions used for hierarchy.

 

abhijitnalekar_0-1632917497300.png

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
Saiteja1
Contributor III
Contributor III
Author

In my case it dosen´t make a difference to check/uncheck "Include Null values" option.