dynamic sort order for expressions

[michael_klix]

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

[michael_klix]

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 good	1	0
country	kpi1	kpi2
a	98	10
b	95	9
c	93	8
d	92	7
e	90	6

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]

cheers    you got the solution