topic Dynamic column change on selection in QlikView

Dynamic column change on selection

abhijitnalekar — Tue, 08 May 2018 07:52:51 GMT

Hi All,

I want to change the column name dynamically on the selection from list box.

Eg. Suppose i have USD,GBP,NOK.. etc values in a list box.

and we have different column in the database like USD_Amount,GBP_Amount,NOK_Amount.. etc

we want to create one variable which changes the the filed name on the selection..

Eg. if we select USD in the list box variable create a value like USD_Amount which is a field name. and that will change on the selection. is this possible.

Thanks

Re: Dynamic column change on selection

rafatashiro — Thu, 17 May 2018 19:50:25 GMT

Hi,

U can create a variable like vCurrency, for example and in the variable definition u have to use something like that:

= if( isnull(GetCurrentSelections(CurrencyFieldName)), 'Select a Currency', CurrencyFieldName & ' Amount')

Then, in the Field Label of the Table/ Chart u use :

= $(vCurrency)

Re: Dynamic column change on selection

rafatashiro — Thu, 17 May 2018 20:04:35 GMT

Or u can try this:

U can create a variable like vCurrency, for example and in the variable definition u have to use something like that:

= if( isnull(GetCurrentSelections(CurrencyFieldName)), 'Select a Currency', Concat(CurrencyFieldName) & ' Amount')

Then, in the Field Label of the Table/ Chart u use :

= $(vCurrency)