Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how do i sort based on selected values

I have a straight table , with multiple dimensions and expressions , I need to sort based on a dimension value selected in the chart ...

so what ever value is selected that has to be appeared on the top of the chart

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You only need to clear selections in the dimension field you want to sort by selection.

Maybe like attached (see sort tab).

edit: Sample QVW deleted on request

View solution in original post

4 Replies
swuehl
MVP
MVP

Not really sure if I understand what you want to achieve.

I think you probably need set analysis in all your expressions to ignore the selection in your dimension field, as far as I understood, you don't want to limit the dimension values based on your selection.

Then you need to create a sort expression that puts the selected value first in order.

Maybe something like attached?

Anonymous
Not applicable
Author

Ok , I ignored all my expression with dimensions values but that will disable my filters correct?

Attached my application .. I basically want the sort order to be by SERVICE API , what ever value is slected should be top of the chart , first records should be the values for selected service api

swuehl
MVP
MVP

You only need to clear selections in the dimension field you want to sort by selection.

Maybe like attached (see sort tab).

edit: Sample QVW deleted on request

Anonymous
Not applicable
Author

Thank you !!

If(Field = GetFieldSelections(Field),-1) , worked!!

Can you please delete the application from your post.