sorting inside the geographic drill down

[mhapanka]

Im using a geographic drill down as a master item in my charts as follows: Region- subregion- country-state-district

The dimension in my bar chart is geographic drill down and the measures are data missing and data available. I have sorted it as Geographic dimension first and by the expression count(districts) in descending so that the region with highest entries comes first. Now when I use the drill diwn by clicking into a region, sub region and country and so on, it is not in descending order and i dont know how to fix this.

Can someone help me on this?

[mhapanka]

Also how can i rename the fields used in a drill down?

[bwisealiahmad · Accepted solution]

Hi,

The sorting you can do in Qlik Sense option for the object where you are using the drll down. As you drill down you need to sort each layer you are on.

So in simple terms:

1) Sort first layer.

2) Drill down to next

3) Sort that layer.

etc. until you have sorted all of them in that object.

And for renaming the fields I would do that in the script.

Simple "AS" Statement.

OriginalFieldName AS NewFieldName

Best,

Ali A