Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
divya_anand
Creator III
Creator III

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

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.

3 Replies
tresesco
MVP
MVP

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

Capture.PNG

qlikview979
Specialist
Specialist

Hi Divya,

not sure are expecting like this

Untitled.png

Anonymous
Not applicable

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".