Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
trishita
Contributor III

Having problems in summing two kinds of data (euro and usd) even after conversion

I have written a code for Total commit in euro as such: 
if (Match([Summary_List.currency],'EUR'), sum([Total Commit]),
if (Match([Summary_List.currency],'USD'), sum(([Total Commit]/ 1.1452 )),
if (Match([Summary_List.currency],'SEK'), sum(([Total Commit]/ 10.32 )),
'Unknown')))

 

But my problem is when I have two kinds (both in euro and usd)of Total commit I am getting no value.For eg Yielco has values for Both Euro and USD but with my logic it is now showing nothing for total commit in euro.I want to see the sum of both the quantities here

 

yielco.JPG

1 Reply
Mauritz_SA
Contributor III

Re: Having problems in summing two kinds of data (euro and usd) even after conversion

Hi Tri**bleep**a

Is your Summary_List.Currency a dimension or a measure in your table? Make sure it is a Dimension.

Regards,

Mauritz