Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

philippon
New Contributor III

Set Analysis: two selections

Hello all

I have a set of data With DateAdminFX, FXIDAdmin, FXPriceAdmin


In a table, I have as a Dimension FXID (which comes from an other set of data), and one Date field called DateD is selected. As an expression in that table, I would like to get FXPriceAdmin where DateAdminFX=DateD (selection) and FXIDAdmin=FXID (the dimension).

I tried =Sum({$<DateAdminFX=DateD,FXIDAdmin=FXID>} FXPriceAdmin) but without luck.

These set analysis drive me crazy, where can we learn more about it? The reference manual is not helping me a lot...

Many thanks

Tags (2)
4 Replies
MVP
MVP

Re: Set Analysis: two selections

Hi,

What about

Sum({$< DateAdminFX = P(DateD), FXIDAdmin = P(FXID) >} FXPriceAdmin)

P() returns all possible values for the field specified.

Hope that helps.

Miguel

philippon
New Contributor III

Re: Set Analysis: two selections

Thanks for your answer but it does not work. I end up with a value I can’t even reconcile, the same for each row, each row dimension being a different FXID it does not make sense.

MVP
MVP

Re: Set Analysis: two selections

Hi Zadig,

Then please share some data we can play with. By the way, are those tables linked somehow?

Regards.

Miguel

philippon
New Contributor III

Set Analysis: two selections

When I use the following formula = Sum({$DateAdminFX=DateD>} FXPriceAdmin) and select FXIDAdmin by a selection box, I get the vaue in my table. The only missing bit is to have the FXIDAdmin to be defined by the dimension.
DateD is selcted to 03/11/2011
My dimension is FXID which is as follow
FXID
CHF
EUR
SEK
DateAdminFX FXIDAdmin FXPriceAdmin
02/11/2011CHF0.822364363333734
02/11/2011GBP1.15730694673495
02/11/2011SEK0.110095056071412
02/11/2011USD0.72458517498732
03/11/2011CHF0.823591617155084
03/11/2011GBP1.1611381011212
03/11/2011SEK0.110558013935838
03/11/2011USD0.727643163792476
Thanks for your help.

Community Browser