Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try
=IF(MAXSTRING({$<Year={$(=Year), $(=Year-1)} >}Product)='Product2','<B>')
For the Text Format expression
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