topic Re: Month Sort in QlikView

Month Sort

Thu, 20 Mar 2014 13:19:36 GMT

My month Data is in excel in proper month order and I loaded the data as a crosstable. However, I am having an issue sorting the months. I do not have specific dates, just the month and the values underneath

Re: Month Sort

MK_QSL — Thu, 20 Mar 2014 13:25:57 GMT

Can you provide your sample data file?

meantime you can use...

Load * Inline

[

Month, MonthNO

Jan, 1

Feb, 2

etc

];

and sort by MonthNO...

ALso you can use Dual Function also.

Re: Month Sort

uttamdwibedy — Thu, 20 Mar 2014 13:26:06 GMT

Provide the sample data file

Re: Month Sort

veeranj — Thu, 20 Mar 2014 13:30:27 GMT

HI Fernando,

GO the the SORT tab and then check Load Order Original option.

Thanks,Anjee

Re: Month Sort

Thu, 20 Mar 2014 13:34:10 GMT

Thanks for the response, here is a picture of how my data is in excel, I tried the Load Order Original and did not work

CrossTable

(SalesMonth, SalesData, 4)
LOAD Version,
[Org Name],
[Sales Type],
Revenue,
JAN,
FEB,
MAR,
APR,
MAY,
JUN,
JUL,
AUG,
SEP,
OCT,
NOV,

DEC

Re: Month Sort

Thu, 20 Mar 2014 13:46:36 GMT

Thank you, this helped!

Re: Month Sort

veeranj — Thu, 20 Mar 2014 14:27:45 GMT

Hi,

here is the other way

in the sort tab ,select months data column and then write this expression

match(months,'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

this will work .

Even the above example what i said is working for me.

the thing is that you have to deselect TEXT(A->Z) OPTION AND THEN select load order original.

for ur reference attching the image.

As ur months are in order in excel ,so u can go for this load order option.

or else u can go for above expression.

Thanks ,

Anjee