Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

samir_bihari
New Contributor

Showing Only Zero or Null Values based on a Variable

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:

SKUDepartmentMonthSales Quantity
1AutoJan 20174
2AutoJan 20175
3ManualJan 20170
4ManualFeb 20170
5ManualFeb 20170
6SemiFeb 2017
7SemiFeb 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?

1 Reply
roharoha
Valued Contributor III

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

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

+ activate supress zero values in chart.

Community Browser