Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks for reply @tresesco
Yes, it is working first condition only - my scenario both should work
can't we include both in one condition ?
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)