Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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...
Help users find answers! Don't forget to mark a solution that worked for you!
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...
Help users find answers! Don't forget to mark a solution that worked for you!