Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

massimofavaro
New Contributor III

Wrong sort of columns with drill down dimension

Hello everyone.

I'm experiencing an issue. I am using the "Sales Discovery" app to test this.

I am creating a column chart with "SUM(Sales)" as measure.

If I use the "Date.autoCalendar.Month", the months are sorted correctly.

Screenshot_2.png

But if I want to use a Drill Down Dimension built this way

Screenshot_3.png

the sorting gets wrong

Screenshot_4.png

I tried using the sort options on the right, but there seems to be no way to fix this.
How can I mantain a chronological order while using a drill down dimension?

Tags (2)
1 Solution

Accepted Solutions
consultant_bi
Contributor

Re: Wrong sort of columns with drill down dimension

Hi Massimo

here is again the solution follow the pictures below :

first go to the edit mode and access to sort menu and choose the week field and then check sort by number and then choose if you want sort ascending or descending:

Sans titre.png

Sans titre2.png

Sans titre3.png

11 Replies
consultant_bi
Contributor

Re: Wrong sort of columns with drill down dimension

Hello

just follow the pictures below

Sans titre.png

Sans titre1.png

don't forget to apply the changes

Sans titre1.png

massimofavaro
New Contributor III

Re: Wrong sort of columns with drill down dimension

Thanks, I appreciate your help, it's correct, but now it's arising another problem.

The first level of the drill down is sorted correctly, but when I drill down one level, the dimension gets mixed up again (it's nor orderered by date ascendent/descendent nor by sales import ascendent/descendent).

For example, if the first dimension is "Month", and the second one is "Week number", the second one gets mixed up again (W11, W12, W14, W13, W10)...

consultant_bi
Contributor

Re: Wrong sort of columns with drill down dimension

hello Massimo

please mark this question as answered by mentioning it as correct and thanks.

agigliotti
Honored Contributor II

Re: Wrong sort of columns with drill down dimension

i think it's a missing feature in Qlik Sense Master Items where it should be a "Sort" settings for each group dimensions as in Qlik View.

I hope it will be added in the next versions of Qlik Sense.

massimofavaro
New Contributor III

Re: Wrong sort of columns with drill down dimension

Does this means that, at the current time, we are unable to define a sorting in a drilled down dimension?

consultant_bi
Contributor

Re: Wrong sort of columns with drill down dimension

Hi Massimo

here is again the solution follow the pictures below :

first go to the edit mode and access to sort menu and choose the week field and then check sort by number and then choose if you want sort ascending or descending:

Sans titre.png

Sans titre2.png

Sans titre3.png

agigliotti
Honored Contributor II

Re: Wrong sort of columns with drill down dimension

at this time in master items you can't.

i guess you can only use the chart sorting options.

massimofavaro
New Contributor III

Re: Wrong sort of columns with drill down dimension

Thanks, it seems to work this way...

I was sure I already tried this.

But it works only in the case there is "Month" -> "Week Number".

If I have Year -> Month name -> week number it doesn't seem to work.

massimofavaro
New Contributor III

Re: Wrong sort of columns with drill down dimension

Yep, I guess I'll have to use a formula to sort the month name. I'm going to look for that.

Yay, I managed doing it by using this formula: "match([Date.autoCalendar.Month], 'Gen', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')".