Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anuhyak1
Creator
Creator

Currency toggle between Local, $, and € in a straight table

I have currency Toggle Local, USD,GBP. 

If user selects Local  textbox Sales value should be displayed with out $ and the expression for Sales Value := num(sum({<$($1)>}SLS_DLRS*$(vCurrency)), '$#,##0') Ex: 80642

If user selects USD  Sales value should be displayed $ in front of  num expression. Ex:$80642

If user selects GBP  Sales value should be displayed  in front of  € num expression.  -Ex: €80642

currency toggle.PNG

Local: For local text box just set two variables.

VCurrency=1

vCurrency_MSRP=LOCAL_MULT

For USD text box

vCurrency= USD_MULT
vCurrency_MSRP =1

 

0 Replies