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

Apply condition on second level of drill down

Hi,

We have calculated fields in drill down and further we want to bar chart differently for each level of drill down. getcurrentfield('DrilldownName') is not working in our case. Is there any other way to apply sort on each level of drill down?

Regards,

Navdeep

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

On Table Properties | Dimensions, click Edit Groups.Select the group, click "Edit". Select the field in the group, and click "Sort Orders" to set the sort criteria for that field.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

You can define the short criteria for each level of the drill-down group using the button "Sort Orders" on the Group Properties dialog.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Not applicable
Author

Hi,

Could you please briefly explain what you meant by sort orders.

Regards,

Navdeep

jonathandienst
Partner - Champion III
Partner - Champion III

On Table Properties | Dimensions, click Edit Groups.Select the group, click "Edit". Select the field in the group, and click "Sort Orders" to set the sort criteria for that field.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan. It worked.

jagan
Luminary Alumni
Luminary Alumni

Hi Navdeep,

While creating the Group you can specify the Sort Order for the dimension in the Group by clicking Sort Order button.  Please find attached screenshot.  In the Group Sort Order screen specify the sorting order either Asc or Desc.

Hope this helps you.

Regards,

Jagan.