topic Re: Set Analysis: two selections in QlikView

Set Analysis: two selections

Anonymous — Thu, 22 Dec 2011 15:00:15 GMT

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

Re: Set Analysis: two selections

Miguel_Angel_Baeyens — Thu, 22 Dec 2011 15:26:02 GMT

Hi,

What about

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

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

Hope that helps.

Miguel

Re: Set Analysis: two selections

Anonymous — Thu, 22 Dec 2011 15:31:41 GMT

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.

Re: Set Analysis: two selections

Miguel_Angel_Baeyens — Thu, 22 Dec 2011 15:37:35 GMT

Hi Zadig,

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

Regards.

Miguel

Set Analysis: two selections

Anonymous — Thu, 22 Dec 2011 16:26:18 GMT

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/2011	CHF	0.822364363333734
02/11/2011	GBP	1.15730694673495
02/11/2011	SEK	0.110095056071412
02/11/2011	USD	0.72458517498732
03/11/2011	CHF	0.823591617155084
03/11/2011	GBP	1.1611381011212
03/11/2011	SEK	0.110558013935838
03/11/2011	USD	0.727643163792476

Thanks for your help.