topic Background color for dimension headers in pivot table in QlikView

Background color for dimension headers in pivot table

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

Hi,

I have following dimension table:

I make a straight table with

dimensions Month and Team:

expression Total:

The variables vFromDate and vTillDate e.g. are set using sliders.

The background color of the dimensions and the expression are set to RGB(180, 255, 255) if the sum is equal or greater than the value in the variable vMaxSumAmount, set to the value 250000.

The result:

Using the same dimensions and expression and expressions for the background colors, I made a pivot table.

But the back ground colors are set for the dimensions Team and Month only when the condition is valid on the first row or on the first column.

How do I need to change the expression for the background colors for the dimensions Team and Month to get the following result instead?

Maybe by using Aggr() function?

Please see example in attachment.

Thanks,

R.W.

Re: Background color for dimension headers in pivot table

Gabriel — Thu, 31 Mar 2016 17:27:49 GMT

Hi,

The problem might be around Date formating.

Your variable vFrom is formatted different

Check all your date formating

Re: Background color for dimension headers in pivot table

maxgro — Thu, 31 Mar 2016 18:52:52 GMT

try the attachment

Re: Background color for dimension headers in pivot table

rudywelvaert — Mon, 04 Apr 2016 07:52:47 GMT

Thanks maxgro,

seems to work, but

What happens there in relationship with the Aggr() and Max() functions?

Does it take the Max() over the temporary table generated by the Aggr() function for every TEAM?

Thanks

R.W.

Re: Background color for dimension headers in pivot table

rudywelvaert — Mon, 04 Apr 2016 07:53:44 GMT

Thanks Gabriel,

I don't think so, otherwise the function wouldn't work for the back color of the individual values either.

R.W.