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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.