Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
marco_puccetti
Partner - Creator
Partner - Creator

List Box sorting

Hello, i have sorted a list box, with a dual function, but i have noticed that the sorting is working only before the selection, after having selected the field, the sorting is lost.

Immagine5.png

Immagine6.png

How can i solve this?

Thanks

Marco

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Try with

=dual(Only({1} [Mese di Decorrenza]),Only({1} [Mese di Decorrenza Num]))


But you probably don't need the dual and can use

=Only({1} [Mese di Decorrenza Num])



View solution in original post

19 Replies
marcus_sommer

You need to disable sorting to state, too.

- Marcus

sunny_talwar

Is this a front end dual function that you are using? If yes then you might want to add {1} to the dual function:

Dual(FirstExpression with {1}, SecondExpression with {1})

Not applicable

what are the settings for your sort order

I can duplicate your issue when I ahve state as decending and numeric and ascending

when I do not use the Ste option, the sorting remains the same as before selction

stigchel
Partner - Master
Partner - Master

Don't know where the dual function comes in (sorting is done on numbers), but in the sort expression use a function that takes set analysis to exclude the selection in this field. e.g.

Only({1} Month)

Or if the field is numeric (or dual) by itself, uncheck the sort by expression and just check sort on numeric value

agni_gold
Specialist III
Specialist III

Hi Friend ,

When you are creating your month field , use

Dual(Month,1)  AS Month

And in listbox , just sort by number .

It will solve your problem .

if still problem exists then please attach your sample application.

Thanks ,

marco_puccetti
Partner - Creator
Partner - Creator
Author

If i uncheck the sorting by expression the dual function in the expression field is disabled.

Marco

sunny_talwar

What is your sort expression right now?

agni_gold
Specialist III
Specialist III

no please make this field at your backend script , it will work fine

marco_puccetti
Partner - Creator
Partner - Creator
Author

The expression is this:

=dual([Mese di Decorrenza],[Mese di Decorrenza Num])

Where have i to insert the {1}? I get syntax error!!

Marco