Discussion board where members can get started with QlikView.
I have used the below code to get the background colour,but for few codes the background colour is not came .
Go to Solution.
Below logic in expression fix the issue.
Logic: if(sum(sales)>0,sum(sales)), which replace zero's with null.
View solution in original post
can you provide some sample data
Thats because CK, MC and DI are no the same name that the one in the field. Check for lower cases or the value.
Is not it because you only have value in the first two columns?
Simulate a case where all columns are not null.
It is because of the first row is null.
Let me know how to get this.