Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to measure a number of "Oders" with a variable condition.
count({$<$(vExclusion_Scope)={'YES'}>} Order)
Here "vExclusion_Scope" is a variable were you have "YES" and "NO" as values. And "Order" is a field name.
The formula isn't working, I don't know why ?
Can you please help me with ?
Thank you in advance for your help.
Best regards, Arun
may be this
If your order has a one value for vExclusionscope
count({<Order={"=$(vExclusion_Scope)='YES' "}>}Order)
@basildur @bramkn only field can be used to set something inside set analysis
you can write <field = {}>
in this case variable is yea and no and is n't a field so { variable = {} } will not work
Have a read
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Thank you very much Pradosh
It's working fine
Best reagrds, Arun
Pradosh Thakur,
It's not working actually... The number that it is calculating, it's not correct...
What is the expression in your variable? May be try like below
extending Pradosh's expr give = to in your set
= count({<Order={"=$(=vExclusion_Scope)='YES' "}>}Order)