How to Dynamically Change expression in Qliksense?

Fri, 15 Sep 2017 06:08:10 GMT

I have a table which has the revenue of all the clients in my organisation.
But the catch is, there is more than 1 column for revenues in different currency.

Clients Name	Revenue USD	Revenue EURO	Revenue INR	Revenue AUD
XYZ Ltd	100	121	430	256

I am using inbuilt KPI to show the Revenue ,However in 1 KPI I can only show revenue of 1 currency.So If I want to show revenue in all four currency,I have to use 4 different KPI's. Which is not feasible for me.

Is there a way to have a radio button or a filter, something like this

Select Currency
USD
INR
EURO
AUD

So If I click/Select on EURO all my values get changed to EURO.?

Thanks in advance.

topic How to Dynamically Change expression in Qliksense? in App Development

How to Dynamically Change expression in Qliksense?