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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
marjan_it
Creator III
Creator III

sort hierarchy level in dimension in chart

Hi All,

I have a table with DepartmentId,DepartmentName, DepartmentParrent

I used Hierarchy query and get Department in 5 level.Department1,Department2,Department3,Department4,Department5

I want to user Department3 with condition in dimension. if(Department2='organization',Department3)

I want to show dimension in a sort order. but it does not work. what could I do ?

0 Replies