Currency calculations on buttons

[Shamshad]

Hi All,

I have requirement to convert normal amount into AED & into USD on the basis of button click.Below is my data source

I have added currencyselection button in qliksense as 

 Lets say user clicked on the AED option so our Total Amount in the qliksense should as 5673.

I have acheived this when i clicked on AED as below

But problem is occuring when we click on USD option,its nothing showing(refer screenshot below).We should have the Total Amount as 1545 on USD selection.

Used Expression on amount column as :

If(GetFieldSelections(Currency_Selection) = 'AED',if(Currency='AED', sum(Amount) * Rate),
If(GetFieldSelections(Currency_Selection) = 'USD',if(Currency='USD', sum(Amount) / Rate2)
)
)

Could anyone please help me in this issue.

Kindly find Datasource sheet & QVF file for the same.

Thanks in advance

[Digvijay_Singh]

Looks like below could be the right expression to achieve what you are expecting - 

If(GetFieldSelections(Currency_Selection) = 'AED',if(Currency='AED', sum(Amount) * Rate),
If(GetFieldSelections(Currency_Selection) = 'USD',if(Currency2='USD', sum(Amount) / Rate2)
)
)

[Shamshad]

Thanks sir for your response.

I am getting the result on Clicking AED or USD button as expected.

But when i am taking only Amount expression in table or in kpi its not showing the result.We need to show amount in Kpi too.

Could you please help me out.

Thanks

[abhijitnalekar]

Hi @Shamshad ,

Please modify the same expression as 

If(
GetFieldSelections(Currency_Selection) = 'AED',if(Currency='AED', sum(Amount) * Rate),
If(GetFieldSelections(Currency_Selection) = 'USD',if(Currency2='USD', sum(Amount) / Rate2),sum(Amount)
)
)

[Shamshad]

Hi @abhijitnalekar

I applied above mentioned expression in the kpi but still its not showing the result 😥 .

[abhijitnalekar · Accepted solution]

Hi @Shamshad ,

Please try this.

If(
GetFieldSelections(Currency_Selection) = 'AED', sum(Amount * Rate),
If(GetFieldSelections(Currency_Selection) = 'USD',sum(Amount/Rate2),sum(Amount))
)

above expression is working at my end.

[Shamshad]

Hi @abhijitnalekar 

Thank you very much,Its working absolutely fine from my end too.