Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hari8088
Creator
Creator

converting inr to us curreny

Hi all

      I have table in that table one field called money.the money field  having  Indian currency.I want change Indian currency to Us currency

in script level it self and i dint want to change in UI level then the UI level it has so show US currency.Is there any function to do this.

Thanks.

4 Replies
amit_saini
Master III
Master III

Hari,

Check if this helps u:

Currency Conversion

Thanks,
AS

MK_QSL
MVP
MVP

When you load the table..you can change money field as below

MoneyField/45 as [MoneyFieldin USD]

Change 45 as per the conversion rate

PrashantSangle

Hi,

For Conversion of Currency you need conversion table where you can map your Indian Currency to US Currency.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
danieloberbilli
Specialist II
Specialist II

something like that:

SET vIndToUSDollar = 0.016;      

Data:

LOAD *,

Value * $(vIndToUSDollar) as Value_in_USDollar

;

LOAD * INLINE [

    ID, Value

    1, 10

    2, 50

    3, 100

    4, 40

    5, 35

];