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: 
Not applicable

Excluding values set analysis

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand