Set Expression for excluding a variable in calculation

[madhur4qlik]

Hi

i have a variable (vHO) and a field Country

(vHO) is a calculating buckets dynamically after some selections

So i am trying to ignore (vHO) in one formula with country.

Count({<Country=,$(=vHO)=>}ID)  is not working.

So i need to use a variable to exclude during a calculation .. can i do that.

[rubenmarin]

Hi Madhur, this can work if vHO contains the field name you want to ignore, you can try adding this expression to a table without caption, so you can see the expression in the column title and check how it's expanding $(=vHO),

Maybe you only need to remove the =:

Count({<Country=,$(vHO)=>}ID)