topic Re: Set Analysis - Multiple Qualifiers on Same field - Less than in QlikView

Set Analysis - Multiple Qualifiers on Same field - Less than

Anonymous — Wed, 21 Oct 2015 15:22:30 GMT

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]))

sunny_talwar — Wed, 21 Oct 2015 15:28:02 GMT

Try this:

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

Anonymous — Wed, 21 Oct 2015 15:30:18 GMT

That worked. Thanks Sunny.

sunny_talwar — Wed, 21 Oct 2015 15:30:42 GMT

Awesome