Discussion board where members can get started with Qlik Sense.
I have a pivot table in which some of the values are '0' and some values are nulls (-). My requirement is to give background color to the "empty cells" and also cells with '0' value.
Can anyone help me on this.
Measure properties, In back ground color expression,
Provide correct RGB color. Hope it will help.
Thanks for your reply,
My Pivot table is having positive, negative, 0 and null values. If I use Sum(Sales)<=0 it will color the negative values and 0 but not the empty cells.