Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
emilyrabbit
Creator
Creator

set analysis - 2 condition in one field

HI , I use set analysis, and I need to restrict [Order Type Mini] 2 condition. But I found only [Order Type Mini]={"<200"} worked. 

[Order Type Mini]={">0"}  didn't work. what should I do?

Count(
{<[Order Type Mini]={">0"},[Order Type Mini]={"<200"},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}
distinct [Order Document Number]
)

Labels (4)
1 Solution

Accepted Solutions
Or
MVP
MVP

You can't use two separate sets on the same field as the latter will override the former (or possibly the other way around, I forget which). You would need to use e.g.

[Order Type Mini]={">0<200"}

View solution in original post

5 Replies
Or
MVP
MVP

You can't use two separate sets on the same field as the latter will override the former (or possibly the other way around, I forget which). You would need to use e.g.

[Order Type Mini]={">0<200"}

emilyrabbit
Creator
Creator
Author

I met another problem, it goes wrong. could you pls help check it ?

Count(

{$<[Order Type Mini]={">0<200"},[Order Purchase Order Number]<>{'*TQBH*'},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}

distinct [Order Document Number]

)

F_B
Specialist II
Specialist II

Hi @emilyrabbit ,

excuse my intromission but what is this highlighted in red? 

[Order Purchase Order Number]<>{'*TQBH*'}

 

Maybe you need 

[Order Purchase Order Number]-={'*TQBH*'}

emilyrabbit
Creator
Creator
Author

HI welcome,

thanks ,I tried . [Order Purchase Order Number]-={'*TQBH*'} failed.

but below works:[Order Purchase Order Number]=-{'*TQBH*'}

Qrishna
Master
Master

Try: Count({$<[Order Type Mini]={">0<200"}, [Order Purchase Order Number]-={"*TQBH*"}, [Order Type Code]={'ZSTD','ZTTB'}, [Fact_Type]={'FACT_ORDER'}>}distinct [Order Document Number])