Set expression

[paulwalker]

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

[tresesco]

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.

[paulwalker]

Thanks for reply @tresesco 

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

can't we include both in one condition ?

[tresesco]

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)