Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sibrulotte
Creator III
Creator III

Sorting with expressions: what happens when a selection is made

Hi,

I am sorting a plain old listbox by this expression %CR099O1.

This works great, but as soon as I have a selection done, the order FLIPS in any which way.

I have the order by State uncheked (and that's basically what I want, my order never to change whatever the selection).

What is the problem here then?

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

You'll want to wrap it around the only function and use set analysis to ignore selections like:

only({1}%CR099O1)

Otherwise, the only %CR099O1 values that will return a number will be the ones you selected and will not keep the sorting consistent through selections.

Hope this helps!

View solution in original post

4 Replies
Not applicable

May you try (just for test) to order Scteurs during Load and than check how it works with only Load Order checked?

sibrulotte
Creator III
Creator III
Author

Hi,

thanks Dariusz, I am not in a position to try that, and insure that the maintenance will allow the load order to be the one I would like.

I can't even try a test to come back with an answer on the validity of your answer.

Thanks again.

jerem1234
Specialist II
Specialist II

You'll want to wrap it around the only function and use set analysis to ignore selections like:

only({1}%CR099O1)

Otherwise, the only %CR099O1 values that will return a number will be the ones you selected and will not keep the sorting consistent through selections.

Hope this helps!

sibrulotte
Creator III
Creator III
Author

It did in did.

Brilliant, I didn't think of a set analysis identifier for sorting...

Thank you.