Discussion Board for collaboration related to QlikView App Development.
How can we Apply Background color for Empty Cells in Pivot Table. cell's may contain Text or Numaric value.
Thanks in Advance
May be using this kind of logic:
If(Len(Trim(YourExpression)) = 0, BackGroundColor, OtherColorWhereThereIsValue)
if you want to do like below :
then see the attached qvw.
Please have a look:
Pivot table background color in cells with no data
Hope it helps!!
Hi for the expression in the expressions tab (properties) click ' + ' and you get a tree , there you select the background
and a condition if(isnull(expression), rgb1(n1,n2,n3),rgb1(n1,n2,n3))
Sorry for forgetting the same you can find for Dimensions also.