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

[Anonymous]

Hi

You have two dimensions right, Change to custom mode and give sorting based on your dimension.

[Anonymous]

Post sample data or app

[svinnakota]

Hi,

I changed into custom mode and applied the expression. However, the second dimension is having nulls. I am thinking that might be the reason where i am not able to sort properly.

Thanks,

Santosh Aravind

[Anonymous]

Might be....uncheck " Show null values " and try once

[arulsettu]

remove the nulls and check it. how do you want to sort the chart. post the app

[svinnakota]

Hi All,

I attached the app. Please take a look at the app and let me know where i need to do the changes.

Thanks,

Santosh Aravind

[svinnakota]

If i add show nulls the data is sorting in the exact descending but i dont want to show nulls. When i uncheck them the sorting is not happening properly.

[arulsettu]

do u want like this ?

if yes in drill down disable sort alphabetically

[Anonymous]

How you want to display?

By Total Population?