Conditional Dimension Format on Pivot Table

[#1]

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

[d_pranskus]

Hi

Try

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

For the Text Format expression

[#3]

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)

  )

to

     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