Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
CSchoene
Partner - Contributor
Partner - Contributor

Flop 5 with NULL values

Hello,

I wanted to create a table with the flop 5 customer.
They all have a turnover but some of them turnover has got null values as their turnover. Surely the flop 5 Customers are the ones without a value but I want to generate a table without these null values.

Now the problem is that I can´t restrict the turnover >0 and generate the flop 5 customer at the same time.

Has someone an idea to solve these problem?

Thank you

Christina

 

Labels (2)
1 Reply
Channa
Specialist III
Specialist III

try to make preceding load 

load * where value>0

Channa