Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

problem writing set expression (exclusion)

The idea behind the expression is:

I want to count all the products where the weight is 0 and the adjusted_weight does NOT equal 0,1.

This is the expression that i had (doesn't give the wanted result):

count({<,emptyings_weight={0}, emptyings_adjusted_weight-={'0,1'}>}product_id)

Can anyone see what is wrong?

Kind regards,

Katleen

12 Replies
Highlighted
Honored Contributor III

Re: problem writing set expression (exclusion)

Try this

count({$<emptyings_weight={0}, emptyings_adjusted_weight-={'0,1'}>}product_id)

Highlighted
MVP & Luminary
MVP & Luminary

Re: problem writing set expression (exclusion)

Remove the first comma. count({<emptyings_weight={0}, emptyings_adjusted_weight-={'0,1'}>}product_id) should work if your field names are the correct case-sensitive names.


talk is cheap, supply exceeds demand
Highlighted
MVP & Luminary
MVP & Luminary

Re: problem writing set expression (exclusion)

Hi,

Remove the first comma in set analysis.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: problem writing set expression (exclusion)

All the suggested solutions don't give me the desired result.

I need the weight to be 0 AND the adjusted weight to NOT be 0.1.

Otherwise it should not count.

Any other ideas?

Highlighted
MVP & Luminary
MVP & Luminary

Re: problem writing set expression (exclusion)

Sure, post the offending document so we can have a look with all the context available.


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

Re: problem writing set expression (exclusion)

count({<product_id = E({<emptyings_adjusted_weight = {'0,1'}>} product_id), emptyings_weight={0}>} product_id)

Highlighted
Not applicable

Re: Re: problem writing set expression (exclusion)

In attachment an example qvw file

Highlighted
Partner
Partner

Re: problem writing set expression (exclusion)

Did you try my suggestion? It should work fine.

Highlighted
Not applicable

Re: Re: problem writing set expression (exclusion)

Your suggestion is used in the example file, doesn't work unfortunalty.

Perhaps you can take a look at the qvw document to see why it doesn't work?

Kind regards,

Katleen