topic Month ordering in List Box and Line Chart in QlikView

Month ordering in List Box and Line Chart

Mon, 07 Dec 2015 12:27:32 GMT

I have two fields for a month, one is the month name and the other is MonthNum

Most of our Clients would have monthNum = 1 for July, 2 for August through to 12 for June.

How would I order the values in a list box and in my line chart dimension. I gather I would need to do it in Sort-Expression but I cannot get the correct code

Re: Month ordering in List Box and Line Chart

Kushal_Chawda — Mon, 07 Dec 2015 12:32:15 GMT

write below expression in sort tab

=match(Monthname ,'Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun')

Re: Month ordering in List Box and Line Chart

Chanty4u — Mon, 07 Dec 2015 12:32:25 GMT

set monthnum='jul',1;

Re: Month ordering in List Box and Line Chart

avinashelite — Mon, 07 Dec 2015 12:36:02 GMT

According to me you could create a Master calendar with normal and finical dates according to the need and you can utilize the same for sorting or other purpose .

Re: Month ordering in List Box and Line Chart

Mon, 07 Dec 2015 12:37:49 GMT

Sorry no, already have it in my code, not sure how the sorting issue would change. Kush's answer works like a dream

Re: Month ordering in List Box and Line Chart

swuehl — Mon, 07 Dec 2015 12:38:59 GMT

Have you tried sort by an expression on sort tab:

=MonthNum

Deselect the other options for now.

I assume MonthNum is linked to your month name field. If you create your month name field like

LOAD *,

Dual(MonthName, MonthNum) as NewMonthField;

LOAD MonthName,

MonthNum,

...

You can just sort all charts / list boxes by sort option 'numeric'.

Re: Month ordering in List Box and Line Chart

Mon, 07 Dec 2015 12:39:16 GMT

Long term needs I might look at that, That though is still a long way off at this stage. Thanks for the hint though

Re: Month ordering in List Box and Line Chart

Mon, 07 Dec 2015 12:42:39 GMT

I tried the first option, will have a look at the Dual statement. I cannot hard code it through. some clients have July as first month of the financial year, other may have other months, so I bring it through in my sql select as two different fields.

I will have a look through, as I read it again I think it may work as well