Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_klix
Creator II
Creator II

dynamic sort order for expressions

Hello,

I have various measurements with a flag "high is good" and country as a dimension.

When presenting them in a bar chart, I want them to sort from "bad to good", meaning the worst are left and the better ones are to the right and potentially I have to scoll to see them.

As mentioned before, with the flag "high is good" altering, some need to be sorted ascending and some descending.

How can I make this depending on the flag?

Hope this was well explained.

Keep Qliking

Michael

11 Replies
michael_klix
Creator II
Creator II
Author

Hi Chanty

(and all who followed up later on the match option),

thanks for the reply(s). However I dont think that match would work as the available Country names (Dimension) are not known to me. In addition to be honest, I did not understand how match could help out here.

I dont want to open another question, but just to clarify the problem, here a draft table:

   

high is good10
countrykpi1kpi2
a9810
b959
c938
d927
e906

When displaying only one KPI in a bar chart, I want KPI1 to be sorted ascending and KPI2 to be sorted descending. So always the worst is left.

Proposed solution is to simply multiply a KPI with (-1) if the "high is good" flag is 0 and use ascending as default sorting order.

rgds

Michael

Chanty4u
Champion III
Champion III

cheers    you got the solution