topic Background color depending of accumulated sum(sales) in QlikView

Background color depending of accumulated sum(sales)

Sun, 17 Feb 2013 20:01:14 GMT

Hi,

I would like to show a chart with two expressions:

sum(Sales) -> bar
sum(Sales) [accumulated] -> line/points

The sort order should be descending for the accumulated sum(Sales). The X-largest values that accumulated to Z% should be shown dynamically in background color darkgray(), the others in lightgray().

Up to now I tried it with 'limited dimensions', 'pareto selection' and 'Aggr(RangeSum(Above(Sum(Sales)...' but didn't succeded.

The problem is show on the first tab in the .qvw, what I already tried on the second tab.

Would be grateful for any help!

cheers

Thomas

Re: Background color depending of accumulated sum(sales)

swuehl — Mon, 18 Feb 2013 00:00:09 GMT

Yes, the limitiation of column sort order when using chart inter record functions like above() is kind of annoying.

But try maybe a a pareto select in an alternate state. Please check attached sample.

Re: Background color depending of accumulated sum(sales)

Mon, 18 Feb 2013 10:02:39 GMT

Works perfect, thanks for the thought-provoking impulse!

Re: Background color depending of accumulated sum(sales)

Tue, 09 Jun 2015 09:03:18 GMT

hi sorry to trouble, could you attach a picture of it so I could refer to? I'm facing the same issue..