Help on Intersect

srik00001 — Tue, 16 Jun 2015 21:25:54 GMT

Hi all,

I am trying to build an intersect calculation

count({$<VALUE_KEY=

P({<CUSTOMER=, SOURCELEVEL2=P(SOURCELEVEL2)>}VALUE_KEY)

P({<CUSTOMER={'Customer X'},SOURCELEVEL3=P(SOURCELEVEL3)>}VALUE_KEY)

>} DISTINCT VALUE_KEY)

The table has Customer as a dimension. How do i pass the Customer dimension value at each row into the second part of the intersection calculation while the first part looks at all customers.

Thanks for your help

Re: Help on Intersect

swuehl — Tue, 16 Jun 2015 22:13:17 GMT

There is no way to pass a dimension's row value into a set analysis expression.

A set expression is evaluated once per chart, not per dimension row.

edit: see this classic post for more details:

Evaluating "sets" in the context of a dimension

topic Help on Intersect in QlikView

Help on Intersect

Re: Help on Intersect