Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmelillo
Contributor II

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

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

Try this:

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

3 Replies

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

Try this:

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

dmelillo
Contributor II

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

That worked. Thanks Sunny.

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

Awesome

Community Browser