Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Indirect Set Analysis

Hi,

Column AColumn BValue
ae1234
ba3422
ce222
da2
eb333
fc222

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?

4 Replies
satishkurra
Valued Contributor II

Re: Indirect Set Analysis

Hi

Refer the below links for syntax and understanding

Indirect Set Analysis for P() and E()

Indirect Set analysis

Re: Indirect Set Analysis

What is the expected output from the 2nd analysis?

Not applicable

Re: Indirect Set Analysis

The expected would be e = 333

Re: Indirect Set Analysis

Try this:

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


Capture.PNG

Community Browser