Sorting order for Drill Down Dimension in Qlik Sense

[svinnakota]

Hi All,

I am havingaissue with Sorting order for Bar chart.

1st Dimension: Country -> State-> City (Drill Down)

          2nd Dimension: Language Known

Measure: Count of Population

Wheniam giving sorting byexpression:Count(population)

The data in the graphis not sortingproperly.

Can someone help me howto makeit work.Please find the attached app forrefrence.

Note: 2nd dimension is having nulls.

Thanks,

Santosh Aravind

[Silambarasan1306]

Hi Santosh,

Here is what you expected. Please find the below attached.

[svinnakota]

Hi All,

I tried the methods which you suggested me. Here in the sort byexpression the distinct function is not working exactly as expected. If I remove the distinct function in the sorting expression, it is working. Did any of you guys face this issue?

Thanks,

Santosh Aravind