topic How to give dynamic color in Histogram chart in QlikView

How to give dynamic color in Histogram chart

yzhang88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All, can someone help me to figure out the expression in Background Color section? I want to get something like this

So I create a histogram to show the distribution of sales for each customer. In dimensions, I use calculated dimension, class(aggr(sum(sales),customerID), 1000). The measurement/expression is count(distinct customerID). Then I got a histogram like above, now I want to show in histogram that x-axis value <5000 with red, otherwise green. Can someone help me with the expression in Background Color?

for example: IF (aggr(sum(sales),customerID)<5000, red(), green()) --this expression doesn't work

Thanks.

Re: How to give dynamic color in Histogram chart

dplr-rn — Mon, 08 Oct 2018 19:06:01 GMT

can you share a sample app?

Re: How to give dynamic color in Histogram chart

yzhang88 — Mon, 08 Oct 2018 19:10:15 GMT

Sorry, I think I can't due to company policy. Any questions I can answer?

Re: How to give dynamic color in Histogram chart

sergio0592 — Mon, 08 Oct 2018 19:13:49 GMT

Scrambling option available in Document properties/Scrambling.

Re: How to give dynamic color in Histogram chart

dplr-rn — Mon, 08 Oct 2018 19:26:02 GMT

dont think additional aggr would work as you have bucketed it already.

i am assuming you want to mark each bucket where sum(Sales) for each customer is less than 5000

one work around would be to calculate average sale prize for each bucket which should satisfy the condition you want. something like

if(sum(Sales)/count(DISTINCT Customer)<5000,red(),green())

hope it works out

Re: How to give dynamic color in Histogram chart

yzhang88 — Mon, 08 Oct 2018 19:43:19 GMT

This workaround looks working for my purpose. Thank you Dilip.

Re: How to give dynamic color in Histogram chart

dplr-rn — Mon, 08 Oct 2018 19:44:50 GMT

no problem. glad it worked out