Discussion board where members can get started with Qlik Sense.
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.
You have two dimensions right, Change to custom mode and give sorting based on your dimension.
Post sample data or app
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.
Might be....uncheck " Show null values " and try once
remove the nulls and check it. how do you want to sort the chart. post the app
I attached the app. Please take a look at the app and let me know where i need to do the changes.
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.
do u want like this ?
if yes in drill down disable sort alphabetically
How you want to display?
By Total Population?