Sum combined with firstsortedvalue

Mon, 27 May 2013 12:35:42 GMT

Hi all,

I have the need to use the sum aggregation filtered by a set analysis expression that contains a firstsortedvalue expression.

For example, I have the following data:

I have a table which contains the first value of F2 order by F4, like below:

F_agg	=if(F_agg='Other',null(), F1)	FirstSortedValue({$<F2-={""},F_agg={'Best'}>}distinct F2,F4)
Best	A	pippo
	B	pippo
	C	ciop

Now my issue is to get in a new column the sum(F3) only for the value of F2 return by firstsortedvalue.

I try with set analysis but without results.

Any idea?

Thanks in advance,

Davide

topic Sum combined with firstsortedvalue in QlikView