topic Re: VARIABLE AS FIELD NAME IN SET ANALISYS in QlikView

VARIABLE AS FIELD NAME IN SET ANALISYS

IE — Mon, 26 Jan 2026 18:19:17 GMT

Good afternoon,

I would like to use a variable as field name in a set expression:

vSystem is a variable which I feed with a list chart and can be 1,2 or 3.

I need to use it like these expresions:

Sum({<vSystem={"1"}>} Quantity)

Sum({<$(vSystem)={"1"}>} Quantity)

But doesn´t work.

Thanks in advance.

Re: VARIABLE AS FIELD NAME IN SET ANALISYS

Vegar — Wed, 24 Aug 2022 21:59:47 GMT

Try using an IF statement instead.

if($(vSystem)=1, Sum(Quantity))

Re: VARIABLE AS FIELD NAME IN SET ANALISYS

Digvijay_Singh — Thu, 25 Aug 2022 03:37:42 GMT

I don't use expressions in left size of set analysis but I was curious to test it, I wanted to do it when I saw @rwunderlich post few months back https://qlikviewcookbook.com/2022/03/expression-as-left-side-of-set-modifier/ but couldn't get chance to do that.

It worked for me though, hope you don't have '=' before the value of your variable

Re: VARIABLE AS FIELD NAME IN SET ANALISYS

marcus_sommer — Thu, 25 Aug 2022 11:02:40 GMT

It will work if your variable contained a valid field-name respectively the expression returned a valid field-name - anything else won't work. A valid field-name means further that values which contain any space or special char are wrapped with quotes or brackets like "Field A" or [Field X] respectively that's called in this way like:

sum({< [$(var)] = {'x'}>} value)

- Marcus