topic Re: List Box Sorting in QlikView

List Box Sorting

Wed, 23 Dec 2015 05:36:46 GMT

Hi All,

i have list box which has date in DEC_13 format , i have dates from DEC_13 to NOV_15. so when i see them in list box they are sorted in ascending order . but when i select any date , the sort order is messing up .

for example when i have list like

DEC_13

JAN_14

FEB_14

MAR_14

But when i click on MAR_14

the order changes to

MAR_14(SELECTED ITEM FIRST)

JAN_14

DEC_13

FEB_14

this is how it is showing in list box,

so kindly any help is appreciated .

Thanks,

Aditya

Re: List Box Sorting

amit_saini — Wed, 23 Dec 2015 05:45:52 GMT

Hi Aditya,

You can try something like below:

Dual(Month,Match(Month,'jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec'))

Thanks,

Re: List Box Sorting

sasikanth — Wed, 23 Dec 2015 05:48:26 GMT

try some thing like below in Sort --> Expression tab

wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Re: List Box Sorting

Anonymous — Wed, 23 Dec 2015 05:51:19 GMT

Try to uncheck this option..Auto Ascending...

Re: List Box Sorting

PradeepReddy — Wed, 23 Dec 2015 05:58:35 GMT

see the attachment...

Re: List Box Sorting

Wed, 23 Dec 2015 06:27:18 GMT

I have faced exact same issue.

Apply soting as screnshot below

Re: List Box Sorting

jagan — Wed, 23 Dec 2015 06:34:18 GMT

Hi,

Uncheck State option in Sort tab of List box properties.

Hope this helps you.

Regards,

jagan.

Re: List Box Sorting

avinashelite — Wed, 23 Dec 2015 07:25:39 GMT

List Box>Properties>Sort>uncheck the sort on the State option

Re: List Box Sorting

Wed, 23 Dec 2015 08:36:15 GMT

Hi All,

Thanks for the input . I am still facing the same problem . i have date field has Dec_13 ,Jan_14 , these are getting sorted on period_Month_Date(12/1/2013) , which is another field . then i can see the list box values are sorted .but when i am giving wildmatch function and also dual ,then clicking some random month for example Mar_15

the result is not even getting sorted and after the click i am not seeing the right sorted values

= wildmatch(only(Period_Date_Format),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

=Dual(Period_Date_Format,Match(Period_Date_Format,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') )

i am still faicng the same problem

Re: List Box Sorting

Wed, 23 Dec 2015 08:52:54 GMT

Hi All,

i got answer from following post

MinString({1} monthfield)

which was in this thread :

Sorting changes when selection is made

thanks anyways