topic Re: List Box sorting in QlikView

List Box sorting

marco_puccetti — Mon, 21 Sep 2015 13:10:55 GMT

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.

How can i solve this?

Thanks

Marco

Re: List Box sorting

marcus_sommer — Mon, 21 Sep 2015 13:15:48 GMT

You need to disable sorting to state, too.

- Marcus

Re: List Box sorting

sunny_talwar — Mon, 21 Sep 2015 13:17:20 GMT

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})

Re: List Box sorting

Mon, 21 Sep 2015 13:19:31 GMT

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

Re: List Box sorting

stigchel — Mon, 21 Sep 2015 13:20:26 GMT

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

Re: List Box sorting

agni_gold — Mon, 21 Sep 2015 13:26:43 GMT

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 ,

Re: List Box sorting

marco_puccetti — Mon, 21 Sep 2015 13:31:47 GMT

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

Marco

Re: List Box sorting

sunny_talwar — Mon, 21 Sep 2015 13:33:02 GMT

What is your sort expression right now?

Re: List Box sorting

agni_gold — Mon, 21 Sep 2015 13:33:33 GMT

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

Re: List Box sorting

marco_puccetti — Mon, 21 Sep 2015 13:36:20 GMT

The expression is this:

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

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

Marco

Re: List Box sorting

marco_puccetti — Mon, 21 Sep 2015 13:39:18 GMT

This not solve the problem.

Marco

Re: List Box sorting

agni_gold — Mon, 21 Sep 2015 13:40:11 GMT

Friend actually , i am saying , please add dual in your calender script , can you please send me your sample application

Re: List Box sorting

sunny_talwar — Mon, 21 Sep 2015 13:40:54 GMT

Try this:

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

Re: List Box sorting

stigchel — Mon, 21 Sep 2015 13:42:50 GMT

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])

Re: List Box sorting

marco_puccetti — Mon, 21 Sep 2015 13:48:54 GMT

This is the dialog in which i have set the dual function.

Marco

Re: List Box sorting

marcus_sommer — Mon, 21 Sep 2015 13:55:57 GMT

Of course it's possible to solve it with a sort-expression but better would be to solve it with native fields within the script - preferably within in a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus

Re: List Box sorting

marco_puccetti — Mon, 21 Sep 2015 14:30:44 GMT

With this statement

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

now the calendar is sorted properly also after selection.

Thanks a lot

Marco

Re: List Box sorting

sunny_talwar — Mon, 21 Sep 2015 14:36:20 GMT

Awesome

If you got what you were looking for, I would request you to close the thread by marking correct answer as well as helpful answers.

Best,

Sunny

Re: List Box sorting

marco_puccetti — Mon, 21 Sep 2015 14:42:40 GMT

Just Done!

Marco

Re: List Box sorting

sunny_talwar — Mon, 21 Sep 2015 14:44:14 GMT

Thank you