topic Re: Set Analysis Selected Value in QlikView

Set Analysis Selected Value

Thu, 11 Jun 2015 13:57:39 GMT

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!

Re: Set Analysis Selected Value

m_woolf — Thu, 11 Jun 2015 16:20:32 GMT

=sum(F2)

Re: Set Analysis Selected Value

Thu, 11 Jun 2015 17:26:23 GMT

I wasn't clear about my rule:

Suppose there are 5 elements, ABCDE, and ABCD are the ones I want to restrict to:

LOAD * INLINE [

F1, F2

A, 1

B, 2

C, 3

D, 4

E, 5

];

I want an expression that when E is selected, the answer is 0. SUM(F2) will give me 5 when E is selected. Thanks.

Re: Set Analysis Selected Value

ramoncova06 — Thu, 11 Jun 2015 17:35:04 GMT

if I understood right you want to exclude at all time "E", but allow F1 to be "dynamic" , this should do it

=sum({<F1= {'$(=(concat({<F1-={'E'}>}F1,chr(39)&','&chr(39))))'} >}F2)

Re: Set Analysis Selected Value

m_woolf — Thu, 11 Jun 2015 17:36:16 GMT

=sum(if(F2<>'E',F2,0))

Re: Set Analysis Selected Value

arthur_dom — Thu, 11 Jun 2015 17:40:47 GMT

Something like the attached?

Re: Set Analysis Selected Value

sinanozdemir — Thu, 11 Jun 2015 17:41:40 GMT

Maybe something like this:

Re: Set Analysis Selected Value

Thu, 11 Jun 2015 18:12:06 GMT

Let's say I have a list of ABCD. When I select something in F1, only what in the list gets calculated. I could have other F1 values EFG....which I don't care, and the expression should be 0.

Re: Set Analysis Selected Value

pratap6699 — Thu, 11 Jun 2015 20:01:56 GMT

sum({<F1=>}F2)

Re: Set Analysis Selected Value

maxgro — Thu, 11 Jun 2015 20:16:19 GMT

SUM({$<F1={'A','B','C','D'}>*<F1=P(F1)>} F2)

Re: Set Analysis Selected Value

Thu, 11 Jun 2015 20:47:10 GMT

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

Re: Set Analysis Selected Value

maxgro — Thu, 11 Jun 2015 20:53:16 GMT

* 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