topic Re: using a variable into value list fucntion in QlikView

using a variable into value list fucntion

jeevays7 — Fri, 01 Jun 2018 06:23:32 GMT

Hi All,

I have a variable (vVALUE) and it has the value : 'A','B','C','D'

variable name: vVALUE, and the value inside the variable will get change based on field selection.

I need to use that variable into value list function for dimension in a table chart.

How to achieve this? Please help me.

sunny_talwar — Fri, 01 Jun 2018 11:28:27 GMT

Would you be able to share a sample to see what you will have?

jeevays7 — Mon, 04 Jun 2018 11:52:55 GMT

Actually i want the expression (valuelist function using variable) like this.

pick(match(ValueList($(vValueList)),$(vValueList)),$(vValueForCal) )

and I got it now and working fine. Thanks for your reply sunny.

jeevays7 — Mon, 04 Jun 2018 11:54:41 GMT

I have s doubt sunny,

How many values can be concatenated and be stored in a variable?

Like vVar1='A','B','C'

vVar=3 value

sunny_talwar — Mon, 04 Jun 2018 11:57:47 GMT

How many values can be concatenated and be stored in a variable?

I am not aware of any limits

jeevays7 — Mon, 04 Jun 2018 12:00:04 GMT

Ok Thank you sunny.

sunny_talwar — Mon, 04 Jun 2018 12:01:04 GMT

No problem. Please close the thread by marking your response as correct.

Best,

Sunny