Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

svinnakota
Contributor

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
Valued Contributor II

Re: Sorting order for Drill Down Dimension in Qlik Sense

Hi

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

qlikviewnovice
Valued Contributor II

Re: Sorting order for Drill Down Dimension in Qlik Sense

Post sample data or app

svinnakota
Contributor

Re: Sorting order for Drill Down Dimension in Qlik Sense

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
Valued Contributor II

Re: Sorting order for Drill Down Dimension in Qlik Sense

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

arulsettu
Honored Contributor III

Re: Sorting order for Drill Down Dimension in Qlik Sense

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

svinnakota
Contributor

Re: Sorting order for Drill Down Dimension in Qlik Sense

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
Contributor

Re: Sorting order for Drill Down Dimension in Qlik Sense

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
Honored Contributor III

Re: Sorting order for Drill Down Dimension in Qlik Sense

Capture.JPG

do u want like this ?

if yes in drill down disable sort alphabetically

qlikviewnovice
Valued Contributor II

Re: Sorting order for Drill Down Dimension in Qlik Sense

How you want to display?

By Total Population?

Community Browser