How to sort month wise in listbox

[kulasekhar]

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.

[alexandros17]

Sort by text

[vishsaggi]

Hi,

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

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

FROM .....;

Regards,

V.

[vardhancse]

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.

[petter]

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....

[awhitfield]

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

[anbu1984 · Accepted solution]

Use this expr in sort tab

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

[prajapatiamar38]

Hi...

Use this expression in sort tab

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

As said by anbu cheliyan

It  is correct.

[kji]

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.

[daniellial]

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