Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Hi,
Could you please briefly explain what you meant by sort orders.
Regards,
Navdeep
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.
Thanks Jonathan. It worked.
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.