Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)
)
)
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
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)
)
)
I applied above mentioned expression in the kpi but still its not showing the result 😥 .
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.