topic Re: Setting different color via Expression in QlikView

Setting different color via Expression

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

Hello guys,

I'm using the following expression to color my bars depending on its value...
If it's above the TTOAL average (red), otherwise (green)

IF(AVG(TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))

But, in this case, if the user selects some bars, the system will recalculate the colors again based on the available remaining bars.

How can do not change the colors in this case?
I mean, once it's calculated the colors should not change anymore upon users' selection.

Would that be as simple as replacing the TOTAL by ALL?

IF(AVG(ALL FSPLU) > AVG(FSPLU), color(3), color(2))

Thanks

Re: Setting different color via Expression

Saravanan_Desingh — Wed, 03 Jun 2020 17:48:33 GMT

So, do you want to compare the overall AVG with currently selected AVG?

IF(AVG({1}FSPLU) > AVG(FSPLU), color(3), color(2))

Re: Setting different color via Expression

brunolelli87 — Wed, 03 Jun 2020 17:51:58 GMT

What's the difference between 1 and ALL?

Thanks

Re: Setting different color via Expression

rwunderlich — Thu, 04 Jun 2020 04:54:32 GMT

You will still need TOTAL

IF(AVG({1} TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))

{1} and ALL are the same. ALL was deprecated when replaced by {1} and ALL was meant to be removed from the product. However, the removal never happened.

-Rob