Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to fix order in a list box

Hi ,

I have a list box which sorted by "Expression".

"Expression is the only check-box checked, and the expression is

=match(MES,'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic')

When there is no month (spanish) selected, the list box is correctly ordered but when there is one selected month the selected one goes to the end or to the beginning of the list.

I would like it remains ordered as it was.

Thanks.

7 Replies
PrashantSangle

Hi,

go to property-> select sort tab->uncheck all options

Resize your list box to full data

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
MK_QSL
MVP
MVP

Convert your MES as below

Month(Date(Date#(MES,'MMM'),'MMM')) as MES

Now in Sort tab of list box

Don't select Numeric Ascending Order

maxgro
MVP
MVP

this seems to works

=wildmatch(only({1} Regione), 'Liguria', 'Lombardia', 'Piemonte', '*')

so in your case should be

=match(only({1} MES),'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic')

preminqlik
Specialist II
Specialist II

Hi there,

use this expression in sort expression

=only({1}match(MES,'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic'))


Hope this helps !



@

Premhas

Not applicable

Hi,

use this expression in sort expression

=avg({1}match({1}match(MES,'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic'))

Hope this will  works !!

srikanthsri1
Specialist
Specialist

create a inline table with the field name and sort order (numeric) and link the field with main field and reload the app

and after that  drop the inline table and do a reload again

Hope it helps

Sri

Not applicable

Earlier, easier correct answer.

Thanks