Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
svinnakota
Creator
Creator

Sorting order for Drill Down Dimension in Qlik Sense

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

11 Replies
qlikviewnovice
Specialist II
Specialist II

Hi

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

qlikviewnovice
Specialist II
Specialist II

Post sample data or app

svinnakota
Creator
Creator
Author

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

qlikviewnovice
Specialist II
Specialist II

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

arulsettu
Master III
Master III

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

svinnakota
Creator
Creator
Author

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
Creator
Creator
Author

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
Master III
Master III

Capture.JPG

do u want like this ?

if yes in drill down disable sort alphabetically

qlikviewnovice
Specialist II
Specialist II

How you want to display?

By Total Population?