Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
abhijitnalekar
Specialist
Specialist

Dynamic column change on selection

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

Regards,
Abhijit
keep Qliking...
2 Replies
rafatashiro
Contributor III
Contributor III

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)

rafatashiro
Contributor III
Contributor III

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)