Qlik Community

Ask a Question

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
nisha_rai
Creator II
Creator II

Issue in currency rate

Hi,

I am facing issue in currency conversion, please help me out to resolve the issue:

Table:

Id,name,month,currency

1,A,Jan-2021,Eur

1,A,Jan-2021,Usd

1,B,jan-2021,Eur

2,A,Feb-2021,Usd

2,B, Feb-2021,Eur

Table2:

Currency,Month,Rate

Eur,jan-2021,3.45

USD,jan-2021,1

Eur,feb-2021,3.25

USD, Feb-2021,1

Expected output:

Name,currency ,rate

A,Eur,3.45/3.25

A,USD,1/1

B,Eur,3.45/3.25

Id,rate

1,3.45/3.25+1/1

I need to show the above two output in two different table

 

Regards,

Nisha

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2 Replies
Taoufiq_Zarra

@nisha_rai 

can you elaborate more how do you do the calculations ? for example A,Eur,3.45/3.25 for A ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
nisha_rai
Creator II
Creator II
Author

If EUR exist in front of feb and jan ,then we have to divide Jan rate to Feb rate,for all Name,one name can have  multiple currency,it may or may not exist in the next month.