https://community.qlik.com/t5/QlikView/sort-hierarchy-level-in-dimension-in-chart/m-p/1815096#M1212935 <P>Hi All,</P><P>I have a table with DepartmentId,DepartmentName, DepartmentParrent</P><P>I used Hierarchy query and get Department in 5 level.Department1,Department2,Department3,Department4,Department5</P><P>I want to user&nbsp;Department3 with condition in dimension. if(Department2='organization',Department3)</P><P>I want to show dimension in a sort order. but it does not work. what could I do ?</P> Wed, 16 Jun 2021 04:25:40 GMT marjan_it 2021-06-16T04:25:40Z https://community.qlik.com/t5/QlikView/sort-hierarchy-level-in-dimension-in-chart/m-p/1815096#M1212935 <P>Hi All,</P><P>I have a table with DepartmentId,DepartmentName, DepartmentParrent</P><P>I used Hierarchy query and get Department in 5 level.Department1,Department2,Department3,Department4,Department5</P><P>I want to user&nbsp;Department3 with condition in dimension. if(Department2='organization',Department3)</P><P>I want to show dimension in a sort order. but it does not work. what could I do ?</P> Wed, 16 Jun 2021 04:25:40 GMT https://community.qlik.com/t5/QlikView/sort-hierarchy-level-in-dimension-in-chart/m-p/1815096#M1212935 marjan_it 2021-06-16T04:25:40Z