Showing Only Zero or Null Values based on a Variable

samir_bihari — Tue, 18 Apr 2017 09:27:03 GMT

Hi Experts,

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:

SKU	Department	Month	Sales Quantity
1	Auto	Jan 2017	4
2	Auto	Jan 2017	5
3	Manual	Jan 2017	0
4	Manual	Feb 2017	0
5	Manual	Feb 2017	0
6	Semi	Feb 2017
7	Semi	Feb 2017

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?

Re: Showing Only Zero or Null Values based on a Variable

Anonymous — Tue, 18 Apr 2017 09:29:26 GMT

if(not sum(Sales Quantity) > 0,' ',null())

+ activate supress zero values in chart.

topic Showing Only Zero or Null Values based on a Variable in QlikView

Showing Only Zero or Null Values based on a Variable

Re: Showing Only Zero or Null Values based on a Variable