Cross Currency Data

jdmarlin — Tue, 15 Sep 2015 20:16:40 GMT

I have an interesting problem I'm stumped with. I have a data set with four currencies: CAD, USD, EUR, GBP, and I want to be able to select a given currency, for example GBP, and have it show me all associated securities and their respective cross currency.... in this case CAD.

So in data set below I have three GBP securities: B, J, and K, and when I select GBP I want it to show me both the CAD and GBP side of those three securities.

Security	Currency	Amount
A	CAD	1000
A	USD	2000
B	CAD	1000
B	GBP	3000
C	CAD	1000
C	USD	2000
D	CAD	1000
D	USD	2000
E	CAD	1000
E	USD	2000
F	CAD	1000
F	USD	2000
G	CAD	1000
G	EUR	4000
H	CAD	1000
H	EUR	4000
I	CAD	1000
I	USD	2000
J	CAD	1000
J	GBP	3000
K	CAD	1000
K	GBP	3000

Result from selecting GBP:

Security	Currency	Amount
B	CAD	1000
B	GBP	3000
J	CAD	1000
J	GBP	3000
K	CAD	1000
K	GBP	3000

Is this possible in QlikView?

Re: Cross Currency Data

maxgro — Tue, 15 Sep 2015 20:55:35 GMT

try with a straight table chart

2 dimensions

Security

Currency

expression

sum({$ <Security=P(Security),Currency=>} Amount)

Re: Cross Currency Data

jdmarlin — Tue, 15 Sep 2015 21:05:14 GMT

And set analysis continues to blow my mind.. thanks!

topic Cross Currency Data in QlikView

Cross Currency Data

Re: Cross Currency Data

Re: Cross Currency Data