topic Conditional Dimension Format on Pivot Table in QlikView

Conditional Dimension Format on Pivot Table

Fri, 28 May 2010 14:13:05 GMT

Hi,

In a pivot table, I want to change dynamically the Text format of the dimension. I'm using set analysis in expression (an expression for current year, a second one for previous year) and the conditional format doesn't work well :

if there isn't value for current year but there is value for previous year, the conditional format doesn't works : it seems that the current dimension value is considered as 'null'.

Do you know how to solve or to workaround this ?

Note : please see the file in attachment to see the problem

Best regards

P.S : I'm working with QlikView 9 SR4

Conditional Dimension Format on Pivot Table

d_pranskus — Fri, 28 May 2010 14:39:45 GMT

Try

=IF(MAXSTRING({$<Year={$(=Year), $(=Year-1)} >}Product)='Product2','<B>')

For the Text Format expression

Re: Conditional Dimension Format on Pivot Table

Thu, 07 Nov 2013 16:25:36 GMT

I had a similar issue to this, where I had conditional formatting on a dimension in a pivot table but if there was no data for a particular filter selection, then the conditional formatting didn't work for the corresponding NULL rows.

Thanks to Darius as your suggestion put me on the right track to fixing this problem.

In case its of use to anyone else - I changed the expression for my dimension background colour from

Pick(

match(Zone,1,2,3),

RGB(255,219,183),

RGB(196,196,255),

RGB(255,255,204)

)

Pick(

match(MAXSTRING({1} Zone),1,2,3),

RGB(255,219,183),

RGB(196,196,255),

RGB(255,255,204)

)

and it works a treat!

cheers

Roz