topic Re: Conditional background on dimension in Pivot in QlikView

Conditional background on dimension in Pivot

Wed, 17 Feb 2016 20:44:35 GMT

Hi,

I currently got a Pivot table with about 5 dimensions (some placed horizontally, some vertically). My third (horizontal) dimension is 'MONEY'. Now I want to set the background color of any cells in this dimension to green when a variable called COLOR_CODE is 0 for said 'MONEY' amount (specified in a table). However the expression for the background color isn't working at all (it's showing random fields in green). Should I specify 'Money' in the statement somewhere, despite it being the dimension?

I've set this as follows;

=If(COLOR_CODE = 0, rgb(108,179,63))

Re: Conditional background on dimension in Pivot

Oleg_Troyansky — Thu, 18 Feb 2016 00:19:55 GMT

it would be helpful to see a small example of your app.

Re: Conditional background on dimension in Pivot

swuehl — Thu, 18 Feb 2016 00:28:33 GMT

Could COLOR_CODE show more than one value per MONEY dimension value?

What do you see in the cells when adding another expression

=COLOR_CODE

If you see a lot of NULL ('-') when you are expecting a value, what do you get with

=CONCAT(DISTINCT COLOR_CODE,', ')

Note that COLOR_CODE is in fact aggregated using Only() function, so this only works if there is a unique value to show.

Use Aggregation Functions!