Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

"Dynamic" currency conversion...

I'm looking for recommendations on the Display elements of Currency conversion.

We have an existing dashboard which is all showing in Euros, as that is our corporate base currency.

However, in anticipation of the request for someone to see it in GBP (which is where we also operate), we've added into the data model the monthly currency conversion factors.

But my main question is how to display the data from a usability perspective.

I am thinking two options:-

  1. Have two sets of sheets - duplicates - based on the different currency - Not very suited to low maintenance, and a night mare if we add another currency (Ok, low risk, but...)
  2. Have a filter / toggle to control the currency. Given everything is in Euros now, this might be ok, but moves the compute from load script to display time, which may in the long run lead to performance issues on the front end. Also, given we don't have the option to dynamically hide columns in tables/pivots, this could lead to more issues.

Can others that have done this sort of thing provide their expertise as to what worked, and what didn't work?


1 Reply
New Contributor III

Re: "Dynamic" currency conversion...

Hello Ian,

i had to apply currency conversion in nearly every single app i worked on.

From experience i can say that the second approach works best for me and I never had any performance issues.

Please have a look at the attached app. Any questions please let me know.

Community Browser