Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to convert a amount into INR( lakhs,CR),$,EUR

how to convert a amount into INR(lakhs,CR),$,EUR

5 Replies
jsanchezh
Partner - Creator
Partner - Creator

I would suggest you to create a variable with the exchange rate and multiply both

Not applicable
Author

thanx jsanchezh

Do anyone have qvw made of amount conversion?

buzzy996
Master II
Master II

Not applicable
Author

Hi Gaurav,

I would strongly recommend to set up a Currency QVD file.

What we have done is to gather information from an XML provided by the Federal state and create a QVD. this QVD has an automatic reload every month, therefore we are always up to date.

This is the script we use to create the QVD.

devise:
LOAD code,
land_de,
land_fr,
land_it,
waehrung,
kurs,
year,
month
FROM
[\\OTG-QVIEW\Report\Data\devises.qvd]
(
qvd);


// recharge de données du taux de change
LOAD code,
land_de,
land_fr,
land_it,
waehrung,
kurs,
$(année) as year,
$(mois) as month
FROM [http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/estv/mittelkurse_xml.php?m=$(mois)&j=$(année)] (XmlSimple, Table is [monatsmittelkurs/devise]);


store devise into \\OTG-QVIEW\Report\Data\devises.qvd (qvd);

As you can see, we get the data and we use STORE to create a QVD file that we can use for any other QVW.

Then, in our main QVW that needed those currency information, we do have this script.

Devises:
LOAD code,
land_de,
land_fr,
land_it,
waehrung,
kurs,
year,
month,
Hash128 (code,year,month) as %Clé_Devise
FROM
[\\OTG-QVIEW\Report\Data\devises.qvd]
(
qvd);



Hope this help.

JP

Not applicable
Author

Hi Gaurav,

I hope it will help you.

Re: Best Practice for Currency

Ramya.