Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sibrulotte
Contributor 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
Valued Contributor II

Re: Sorting with expressions: what happens when a selection is made

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!

4 Replies
Not applicable

Re: Sorting with expressions: what happens when a selection is made

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

sibrulotte
Contributor III

Re: Sorting with expressions: what happens when a selection is made

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
Valued Contributor II

Re: Sorting with expressions: what happens when a selection is made

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
Contributor III

Re: Sorting with expressions: what happens when a selection is made

It did in did.

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

Thank you.

Community Browser