Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Selected Value

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!

11 Replies
Not applicable
Author

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

maxgro
MVP
MVP

*     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