Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jdmarlin
Contributor III
Contributor III

Cross Currency Data

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.

   

SecurityCurrencyAmount
ACAD1000
AUSD2000
BCAD1000
BGBP3000
CCAD1000
CUSD2000
DCAD1000
DUSD2000
ECAD1000
EUSD2000
FCAD1000
FUSD2000
GCAD1000
GEUR4000
HCAD1000
HEUR4000
ICAD1000
IUSD2000
JCAD1000
JGBP3000
KCAD1000
KGBP3000

Result from selecting GBP:

   

SecurityCurrencyAmount
BCAD1000
BGBP3000
JCAD1000
JGBP3000
KCAD1000
KGBP3000

Is this possible in QlikView?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with a straight table chart

2 dimensions

     Security

     Currency

expression

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

View solution in original post

2 Replies
maxgro
MVP
MVP

try with a straight table chart

2 dimensions

     Security

     Currency

expression

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

jdmarlin
Contributor III
Contributor III
Author

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