topic Sort Order of Month-Day Dimension in QlikView

Sort Order of Month-Day Dimension

Fri, 08 Apr 2016 15:18:27 GMT

I have a bar chart that is comparing total amount based on month/day, which is a created the field created by MONTH(DateField) & "-" & DAY(DateField). I am having issues with the dates showing in the correct order on the axis. I was able to put the months in order by doing a match statement. What is the best way to go about putting the months/days in order? Is there a different way to create the month/day field that will automatically put them in order?

Re: Sort Order of Month-Day Dimension

sunny_talwar — Fri, 08 Apr 2016 16:51:33 GMT

May be create this field like this:

Dual(Month(DateField) & "-" & Day(DateField), DateField)

Re: Sort Order of Month-Day Dimension

MarcoWedel — Sat, 09 Apr 2016 01:02:55 GMT

maybe also possible to create dual values (instead of your text only values):

Date(DateField,'MMM-DD') as [Month-Day]

or if you want to unify the year in order to compare your Month-Days between different years:

Date(SetDateYear(DateField,2000),'MMM-DD') as [Month-Day]

hope this helps

regards

Marco

Re: Sort Order of Month-Day Dimension

maxgro — Sat, 09 Apr 2016 11:20:53 GMT

I think you can sort by expression in the sort tab of the chart

max(DateField)

Re: Sort Order of Month-Day Dimension

kkkumar82 — Sat, 09 Apr 2016 11:38:10 GMT

Better create a autonumber on that field in the edit script like YearDateNum and use this in the chart -> sort->expression->YearDateNum;

Hope I am clear

Re: Sort Order of Month-Day Dimension

kkkumar82 — Sat, 09 Apr 2016 12:24:04 GMT

PFA file