Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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)