Discussion Board for collaboration on QlikView Layout & Visualizations.
So i made a pivot table and for 1 dimension, i made a conditional color for the background.
problem is: it also fills the 'Total' field.
how do i make this go away?
see attached image for clarification..
If(rowno()=0 or isNull(rowno()),Null(),If(Sum(Sales) > 300,Red(),Yellow()))
View solution in original post
try this go to settings->user preference->design
and change default styling mode default to advanced
and now right click on the total cell and click on custom format cell and change the Background color for the total cell
What is your background color expr?
if ( expression > 1,red(),green())