Discussion Board for collaboration on QlikView Scripting.
I have come across a situation where I need to display only the zero values if a variable is on. Below is the table data and scenario:
I have a variable called NoSales. What I want is if NoSales = 1 , then the table should show only SKU no 3,4,5,6,7 i.e where quantity is 0 or no value.
how I can achieve this?
if(not sum(Sales Quantity) > 0,' ',null())
+ activate supress zero values in chart.