How to Dynamically Change expression in Qliksense?

Ask a Question

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.

0 Replies