how do i sort based on selected values

[Anonymous]

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

[swuehl]

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]

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 · Accepted solution]

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]

Thank you !!

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

Can you please delete the application from your post.