Problems with sorting on drill down dimension - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-09-30

I have a line graph on a drill down dimension (month - day). The data shows up fine at first (when showing months) but when I drill down into a month (select a month and click confirm) the dates are not sorted properly but appears in what seem as random order. I have tried different sorting options in the chart configuration but without any luck.

Before selection:

After selecting a month:

Any help is appreciated!

/Viktor

Report Inappropriate Content · ‎2014-10-31

Thanks,

I used another tip of yours. (Qlik Sense Desktop - how can I filer by date? | Qlik Community)

Is there a function to filter out only one year in the data load editor, like if you have dates from 2011 to 2014 and want only to get the 2014 dates and related content.

LOAD "No_" as Projekti,

Year2014("Creation Date") as Year-2014

or something similar..

JonnyPoole · ‎2014-10-31

Hi max - for sure - can you put this in a new thread ? it makes it easy for other users to find solutions.