topic Re: Set Expression for excluding a variable in calculation in QlikView

Set Expression for excluding a variable in calculation

madhur4qlik — Fri, 22 Sep 2017 15:53:22 GMT

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.

Re: Set Expression for excluding a variable in calculation

rubenmarin — Fri, 22 Sep 2017 16:19:58 GMT

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)