How to include and exclude null values using SET Analysis

[Anonymous]

Requirements: count distinct ProductID for below condition

1) include only Created status

2) include only when Customer_demand is not null

3) exclude when ImportID is not null

[maxgro]

intersection

[maxgro]

please close the discussion if you get the answer (mark helpful and correct...., there are already so many open thread); thanks and good qlik

[Anonymous]

massimo,

so if Class 3,6 and 7 is to be excluded, is this the correct expn:

count(distinct{<Status={'created'}> *<Class=-{'3','6','7'}>* <Customer_demand={'*'}> *  -<ImportID={'*'}>}ProductID)

this expn is working in this app but when I tried to apply the same logic in my other app, the count was 0. I was curious if you see any thing not right in here,

Thanks