using a variable into value list fucntion

[jeevays7]

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]

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

[jeevays7 · Accepted solution]

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]

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]

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

I am not aware of any limits

[jeevays7]

Ok Thank you sunny.

[sunny_talwar]

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

Best,

Sunny