Excluding values set analysis

Fri, 24 May 2013 10:19:53 GMT

Hi,

I don't be able to use the set analysis to retrieve excluded values.

I have the following table:

F_agg	=if(F_agg='Other',null(), F1)	FirstSortedValue({$<F2-={""}>}distinct F2,F4)	concat(DISTINCT F2, chr(10))
Best	A	pippo	pap pippo pluto
	B	pippo	cip paperone pippo pluto
	C	ciop	ciop minni pippo pluto
Other		pippo	ciop cip minni pap paperone pippo pluto

In the first column I get the first value of F2 order by F4.

In the second column I get the list of F2 values.

I want a third column that visualize all F2 values except for the first value (in example A, the column must contain all values except for 'pippo').

I try with set analysis but without success.

I attach my application file.

Any idea?

Thanks in advance.

Davide

Re: Excluding values set analysis

Gysbert_Wassenaar — Fri, 24 May 2013 10:34:05 GMT

See attached qvw