Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis - Multiple Qualifiers on Same field - Less than

Couple of questions here -

1. What is the best way to apply multiple qualifiers to the same field in set analysis?

2. What is the best way to apply a less than qualifier to a certain field?

Example is below: Trying to count distinct items where the Code is NOT LIKE 152621* and is less than 15400000

count({<

[Code]-={'152621*'},

[Code] ={"< $(=15400000)"}

DISTINCT(

[Item Number]))

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Count({<Code -= {'152621*'}>*<[Code] ={"<15400000"}>} DISTINCT([Item Number]))

View solution in original post

3 Replies
sunny_talwar

Try this:

Count({<Code -= {'152621*'}>*<[Code] ={"<15400000"}>} DISTINCT([Item Number]))

Anonymous
Not applicable
Author

That worked. Thanks Sunny.

sunny_talwar

Awesome