Count if with a varaible condition

[arun2305]

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

[bramkn]

I have never tried a variable as the fieldname in a set analysis. U sure this is possible?

[pradosh_thakur]

may be this 

If your order has a one value for vExclusionscope

count({<Order={"=$(vExclusion_Scope)='YES' "}>}Order)

[basildur]

Or perhaps Count( {<$[(vExclusion_Scope)]={'YES' }>} Order )

[pradosh_thakur]

@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

[arun2305]

Thank you very much Pradosh

It's working fine

Best reagrds, Arun

[bramkn]

You didnt understand what I was saying.
I know this isn't possible...

[arun2305]

Pradosh Thakur,

It's not working actually... The number that it is calculating, it's not correct...

[pradosh_thakur]

@bramkn  I must have misread . My applogies.

@arun2305  what's your variable looks like ?

[vishsaggi]

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)