topic Set expression in QlikView

Set expression

paulwalker — Fri, 12 Nov 2021 05:37:01 GMT

Hi Community,

I'm working existing application, bit confuse with below expression - can you please explain

Count({<ID={""""=Sum({Index={1000}>|Sales)>0""""},ID={""""=Sum({Index={1000}>|Sales)<3.5""""}>}ID)

what I understood ID count should be between 0-3.5 ?

This expression is not working for me, do we have any other way to write ?

Thanks in advance

Re: Set expression

tresB — Fri, 12 Nov 2021 05:48:01 GMT

Assuming that repeated quotes are typo. Now with two ID conditions, only your first condition, i.e. >0 would be in effect. Therefore, effectively it NOT between but only greater than that would work. Qlik only takes first filter when there are many for the same field.

Re: Set expression

paulwalker — Fri, 12 Nov 2021 06:17:11 GMT

Thanks for reply @tresB

Yes, it is working first condition only - my scenario both should work

can't we include both in one condition ?

Re: Set expression

tresB — Fri, 12 Nov 2021 06:21:50 GMT

Yes, of course we can. Sometimes it is simpler than we think. Try like:

Count({<ID={"=Sum({<Index={1000}>} Sales)>0 AND Sum({<Index={1000}>}Sales)<3.5 "}>}ID)