Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhijitnalekar
Specialist II
Specialist II

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...
Help users find answers! Don't forget to mark a solution that worked for you!
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)