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. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabelaa_123
Contributor II
Contributor II

Daily currency converter

Hi,

I need to convert the sum of the daily currency converter.

In the KPI view, I need to see this sum.

examples:

I have two tabels

The first table tells about the exchange rate

 

Currency USD EUR
2022-04-12 3.1108 4,12
2022-04-13 6.886 3,6
2022-04-14 6.886 4,2
2022-04-15 6.886 3,3

 

The first table tells about revenues

Table reve
2022-04-12 6000
2022-04-13 485
2022-04-14 3654
2022-04-15 415

 

Both tables are linked with the data key

how can i write the correct function?

In the table, I can do it without any problem, but it has a problem with the KPI view

Any help would be greatly appreciated.

Regards

I.

Labels (1)
2 Solutions

Accepted Solutions
vinieme12
Champion III
Champion III

MapUSD:

Mapping Load

Date,USD

From Currentdata;

 

MapEUR:

Mapping Load

Date,EUR

From Currentdata

 

Temp:

Load 

Date

,Revenue

,Applymap('MapUSD',Date,1)*Revenue as Revenue_USD

,Applymap('MapEUR',Date,1)*Revenue as Revenue_EUR

From Factdata;

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

vinieme12
Champion III
Champion III

OR in frontEnd

Revenue_USD:

=sum(Revenue * USD)  

 

Revenue_EUR:

=sum(Revenue * EUR)  

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

MapUSD:

Mapping Load

Date,USD

From Currentdata;

 

MapEUR:

Mapping Load

Date,EUR

From Currentdata

 

Temp:

Load 

Date

,Revenue

,Applymap('MapUSD',Date,1)*Revenue as Revenue_USD

,Applymap('MapEUR',Date,1)*Revenue as Revenue_EUR

From Factdata;

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

OR in frontEnd

Revenue_USD:

=sum(Revenue * USD)  

 

Revenue_EUR:

=sum(Revenue * EUR)  

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.