Enter a variable input to change (simulate) currency

[JelleSchuermans]

Hello experts

I have a table with a number of currencies. Now for a simulation/what if sheet I want to change the value.
In QlikView this can be done with an inputfield, but in QlikSense it doesn't work.

So I want to use a variable input that gives the SP_ConversionRate value that I can change.
I created a variable: 'EUR_Currency' with the following expression: only({<SP_Currency={'EUR'}>} SP_ConversionRate)
But it does not give me the SP_ConversionRate value of 1. (I have to do the same for CLP, ... )

Can anyone see what my mistake is?

Thanks in advance!

[MayilVahanan]

HI @JelleSchuermans 

I think, you've missed out the equal sign. Try like below

And also, hope you've only one value for EUR conversation rate. If not, try with Min() or Max()