sort according to the selections in the list box (ad hoc)

[divya_anand]

Hello,

I am trying to sort the bar chart according to the selections made in the list "_met". For eg: When I select "Open" and "Closed", the bar chart must be sorted in such a way that it should take the total = Open + Closed and then sort in descending order. Can someone help me with this scenario?

Thank you.

[tresesco]

May be you should take _met as a dimension, like this?

[qlikview979]

Hi Divya,

not sure are expecting like this

[Anonymous]

I think we can add another expression like "aggr(count(distinct{<Status={'Open'}>}ID)+count(distinct{<Status={'Closed'}>}ID),Name)". So that it can sort accordingly with the total count of "OPEN" and "CLOSED".