topic Re: dynamic variable name with columnno() in pivot chart expression in QlikView https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304661#M406225 <HTML><HEAD></HEAD><BODY><P>Can you show the image, Where you are trying this</P></BODY></HTML> Wed, 12 Apr 2017 08:51:29 GMT Anil_Babu_Samineni 2017-04-12T08:51:29Z dynamic variable name with columnno() in pivot chart expression https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304660#M406224 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>if I use 'vcalc' &amp; ColumnNo() in a chart expression in a pivot table, I see this in the cells: vcalc1, vcalc2... as text.</P><P>Looks good so far.</P><P>But I would need to use is as variable names.</P><P>I have different variables for each column in a pivot table.</P><P>How to convert the text created with 'vcalc' &amp; ColumnNo() into a variable name?</P><P></P><P>I tried different things like:</P><P>=$($(='vcalc' &amp; ColumnNo()))....</P><P>but nothing works.</P><P></P><P>Any idea?</P><P></P><P>Roland</P></BODY></HTML> Wed, 12 Apr 2017 08:38:37 GMT https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304660#M406224 Anonymous 2017-04-12T08:38:37Z Re: dynamic variable name with columnno() in pivot chart expression https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304661#M406225 <HTML><HEAD></HEAD><BODY><P>Can you show the image, Where you are trying this</P></BODY></HTML> Wed, 12 Apr 2017 08:51:29 GMT https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304661#M406225 Anil_Babu_Samineni 2017-04-12T08:51:29Z Re: dynamic variable name with columnno() in pivot chart expression https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304662#M406226 <HTML><HEAD></HEAD><BODY><P>in the definition of a chart expression</P></BODY></HTML> Wed, 12 Apr 2017 08:53:26 GMT https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304662#M406226 Anonymous 2017-04-12T08:53:26Z Re: dynamic variable name with columnno() in pivot chart expression https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304663#M406227 <HTML><HEAD></HEAD><BODY><P>doing the same with RowNo() works fine.</P></BODY></HTML> Wed, 12 Apr 2017 08:54:02 GMT https://community.qlik.com/t5/QlikView/dynamic-variable-name-with-columnno-in-pivot-chart-expression/m-p/1304663#M406227 Anonymous 2017-04-12T08:54:02Z