Sorting QlikView chart by expression

[roland74]

Hi all,

I have a bar chart with 3 expressions (unit price, unit cost and margin) but I want to sort the chart by sales volume so it will start with the biggest product group (dimension) instead of the biggest unit price..

I already tried to achieve this on the sort sheet by putting in sum([sales volume]) in the expression field but no luck so far.

Anybody with an idea?

Thanks in advance!

Roland

[kkkumar82]

Hi ,  As per your try it should work.  Can you post a sample qvw with a inline data.  Thanks Kiran

[roland74 · Accepted solution]

Hi Kiran,

Thanks for responding!

I think I figured it out..... there was a dimension limit on the chart that showed only the 10 largest values (no expression possible here).

It overrules the sort by expression, I think there is no option for a dimension limit with an alternative sorting?

Thanks Roland