Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
divya_anand
Contributor II

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.

Tags (3)
3 Replies
MVP
MVP

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

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

Capture.PNG

qlikview979
Valued Contributor

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

Hi Divya,

not sure are expecting like this

Untitled.png

lavanyajune1520
New Contributor

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

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

Community Browser