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: 
zyevniyeva
Partner - Contributor II
Partner - Contributor II

Currency Selection feature in QlikView

Hello,

Our team has developed a QlikView application for banks offering multiple dashboards, there we have a feature of currency change, this way using the button with currency translation functions, we can quickly change from dollar to euro etc in "real time". For each calculation the expression contained several "IF"s for each currency, so when we selected the button, the values were accordingly changing.  


Now we want to adapt the app for QlikSense, so maybe anyone has ever done this before and if yes - how. We have tried to use variables and same "IF"s but that doesn't seem to be right solution. Does anyone have an idea, would be glad to hear from you,


thank you.  

2 Replies
undergrinder
Specialist II
Specialist II

Hi Zhanike,

I think it can be done with the following extension and variable, as you mentioned.

Qlik Branch

If not works, then try with variable, that defined at GUI.

What was the pitfalls, that block the adaption?

you can use the variable to count the result by currency

=[field] * $(currency_rate)

G.

MK9885
Master II
Master II

Wht is your If condition?

Do have currencies stored in a table or you hard coding it in front end?