topic Re: Indirect Set Analysis in QlikView

Indirect Set Analysis

Thu, 21 Apr 2016 16:21:39 GMT

Hi,

I want to build a analysis depending from my selection in Module A.

e.g. I select a in the first column and with the corresponding value in Column B (e) I want to do an additional analysis

1. Analysis (Simple ツ ) Sum(Value)

2. Analysis

Sum({1<[[Column A]]=P({<[[Column A]] = [[Column B]]>})>} Value)

Maybe I am totally on the wrong way?

Any suggestions?

satishkurra — Thu, 21 Apr 2016 16:31:05 GMT

Refer the below links for syntax and understanding

sunny_talwar — Thu, 21 Apr 2016 16:35:39 GMT

What is the expected output from the 2nd analysis?

Thu, 21 Apr 2016 20:38:35 GMT

The expected would be e = 333

sunny_talwar — Thu, 21 Apr 2016 20:42:52 GMT

Try this:

=Sum({1<[Column A] = p([Column B])>}Value)