Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Agrimjain1
Contributor
Contributor

Can Someone help me ??

I need help in Cracking this....

3 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @Agrimjain1 ,

Please check the attached QVW file.

Let me know if you have any issues.

Some exchange rate combinations are missing in provided QVD. Try the same solution on the full set of data.

Regards,
Abhijit
keep Qliking...
Agrimjain1
Contributor
Contributor
Author

Thnxx for the qvw file but i am woking in sense and i need the code in data load editor......

abhijitnalekar
Specialist II
Specialist II

please see the below code.

 

LOAD [Doc Currency]&date([Billing Date],'YYYY-MM-DD') as currkey,

[Doc Currency]&date([Billing Date],'YYYY-MM-DD') as currkeyI,
[Billing Doc],
[Billing Item],
Material,
[Billing Qty],
[Billing Value],
Division,
Plant,
[Pricing Date],
[Sales Group],
[Material Group],
[Cost Center],
[Sales Office],
Batch,
[Storage Loc],
ProfitCenter,
[Product Line ID],
Program,
[Sales Order No],
[Sales Order ItemNo],
[Delivery Number],
[Delivery Item],
Cost,
[Sales Organization],
[Billing Type],
[Billing Category],
[Distribution Channel],
[Customer ID],
Date([Billing Date],'YYYY-MM-DD')as [Billing Date],
[Doc Currency]
FROM
[C:\Users\Rugved\Downloads\Invoice.qvd]
(qvd);

LOAD [From Currency]&[Effective Date] as currkey,
[From Currency]&[Effective Date] as curkeyT,
[From Currency],
[To Currency],
[Effective Date],
[Conversion Rate],
[Conversion Factor]
FROM
[C:\Users\Rugved\Downloads\Currency.qvd]
(qvd);

Regards,
Abhijit
keep Qliking...