Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is my data:
LOAD * INLINE [
F1, F2
A, 1
B, 2
C, 3
D, 4
];
this is my expression: SUM({$<F1={'A','B','C','D'}>} F2), which gives me 10 all the time no matter I choose either one of F1 or all of them.
I want: when I choose A, the expression gives me 1; when I choose B, the expression gives 2; when I choose nothing, the expression gives me 10. How do I do that? Thanks!
Thank you! Can you also explain a little bit or direct me to the resource?
* Intersection. This binary operation returns a set consisting of the records that belong to both of the two set operands.
P possible values
some set analysis resources
QlikView help (F1, set analysis)