topic Re: Variable's dimension value in expression's chart tab in QlikView

Variable's dimension value in expression's chart tab

Mon, 01 Sep 2014 11:13:24 GMT

Dear all,

I have loaded 4 dimensions with numeric names [1],[2],[3],[4] and one variable (v1) and it's allowed values are the numbers (1,2,3,4). I have a chart object and I need the definition on the expression tab to use the value of this variable.

For example :

If v1=2

I want the expression to return the dimension [2]. I tried using the following definition =$(=v1) but it is not correct. Can anyone help me please?

Thank you in advance

Re: Variable's dimension value in expression's chart tab

tresB — Mon, 01 Sep 2014 11:17:36 GMT

Square brackets are important in this case, Try like:

=$(='['&v1&']')

Re: Variable's dimension value in expression's chart tab

Mon, 01 Sep 2014 11:19:30 GMT

Yes it worked. Thank you very much mr tresesco for your valuable time