topic SET Analysis with OR? in QlikView

SET Analysis with OR?

Tue, 22 Feb 2011 17:32:08 GMT

Hi,

i would like to build a SET Analysis with a 'OR':

=SUM({$<YEAR = {"$(=max(YEAR-1))"},MONTH = {"<=$(=max(MONTH))"}, Group={$(=vRA)}>} $(vREV))

We have a Group of customers but i want to add ONE other customer (He is not part of the Group.

Is this possible?

Many Thx

Christoph

vgutkovsky — Tue, 22 Feb 2011 17:43:23 GMT

Christoph,

The + sign is the OR operator in set analysis. So, for example: sum({<Group={$(=vRA)}>+<CustomerID={"123456"}>} $(vRev))

Regards,

martin59 — Tue, 22 Feb 2011 17:47:03 GMT

Hi,

You can try that :

=SUM({$<YEAR = {"$(=max(YEAR-1))"},MONTH = {"<=$(=max(MONTH))"}>*(<Group={$(=vRA)}>+<Customer={XX}>)} $(vREV))

Hope that helps you.