topic Currency Selection feature in QlikView in App Development

Currency Selection feature in QlikView

zyevniyeva — Mon, 06 Aug 2018 04:26:38 GMT

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.

Re: Currency Selection feature in QlikView

undergrinder — Tue, 07 Aug 2018 09:22:47 GMT

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)

Re: Currency Selection feature in QlikView

MK9885 — Tue, 07 Aug 2018 17:00:54 GMT

Wht is your If condition?

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