Set Analysis Selected Value

[#1]

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!

[#2]

Thank you! Can you also explain a little bit or direct me to the resource?

[maxgro]

*     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)

A Primer on Set Analysis

Set Analysis: syntaxes, examples