Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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

lavanyajune1520
Contributor
Contributor

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