topic Re: How to sort month wise in listbox in QlikView

How to sort month wise in listbox

kulasekhar — Fri, 29 May 2015 08:23:40 GMT

Hi All,

I have one listbox. find the atach ment.

I want display data month wise like Jan-13

Jan-14

Jan-15

Feb-13

Feb-14

Feb-15 Like this

Thanks

Sekhar.

Re: How to sort month wise in listbox

alexandros17 — Fri, 29 May 2015 08:25:55 GMT

Sort by text

Re: How to sort month wise in listbox

vishsaggi — Fri, 29 May 2015 08:33:52 GMT

Hi,

You can use this expression while loading. Using Date() Function.

LOAD Date(Date(DateColumn, 'MM/DD/YYYY'), 'MMM-YY') As DateColumn

FROM .....;

Regards,

Re: How to sort month wise in listbox

vardhancse — Fri, 29 May 2015 08:37:24 GMT

Hi,

If we create calendar in qlikview and join to the fact table, then for every month we will give number so that we can sort based on number.

Re: How to sort month wise in listbox

petter — Fri, 29 May 2015 08:37:35 GMT

The ability of QlikView to store values as DUAL like the date does makes it possible to have a text-representation - in this case Jan-15 to be the displayed text and the underlying value can still be a complete date value which will sort correctly - since with dual-values by default are treated like numbers in sorting....

Re: How to sort month wise in listbox

awhitfield — Fri, 29 May 2015 08:49:49 GMT

Hi Kula,

looks like a custom sort order, you could add a sort flag field as below:

Data:
Load * Inline
[
Date, SortFlag
Jan-13,1
Jan-14,2
Jan-15,3
Feb-13,4
Feb-14,5
Feb-15,6
];

Then use this to sort by expression, simple example attached

Re: How to sort month wise in listbox

anbu1984 — Fri, 29 May 2015 09:14:10 GMT

Use this expr in sort tab

=Date#(Left(Mth,3),'MMM') + Right(Mth,2)

Re: How to sort month wise in listbox

prajapatiamar38 — Fri, 29 May 2015 09:37:01 GMT

Hi...

Use this expression in sort tab

=Date#(Left(Month,3),'MMM') + Right(Month,2)

As said by anbu cheliyan

It is correct.

Re: How to sort month wise in listbox

kji — Fri, 29 May 2015 10:58:16 GMT

You don't even need the SortFlag, if you make a single column table and put it early in the script (so that it is the first time the field occurs) you can use LoadOrder to sort it.

Re: How to sort month wise in listbox

daniellial — Fri, 29 May 2015 11:31:51 GMT

You could create a field like a key date, with MMYYYY format, and then order by that field.

Re: How to sort month wise in listbox

Peter_Cammaert — Fri, 29 May 2015 12:04:13 GMT

Or maybe shorter (I'm guessing that your listbox already contains a Date() value)?

= Month(DateField)*10000+Year(DateField)

Also works for months in the previous century. Or in the next one

Peter

Re: How to sort month wise in listbox

kulasekhar — Fri, 29 May 2015 15:11:35 GMT

Thanks a lot Anbu.Helping me