topic Re: Intersection within set analysis in QlikView

Intersection within set analysis

somenathroy — Thu, 30 Mar 2017 13:10:59 GMT

Hi All,

I am looking for a help to write a set analysis for a query. Suppose my data looks as below:

data:

Load * Inline

[person,day,sales

a,sun,10

a,mon,20

a,tue,30

b,thu,22

c,mon,20

d,sun,12

d,mon,11];

I require to show person wise sales having sales on 'sun' AND 'mon' both days. Thus the result table should looks as below:

Person	Sales
a	30
d	22

Regards,

Som

sunny_talwar — Thu, 30 Mar 2017 13:15:49 GMT

May be this

Sum({<person = p({<day = {'sun'}>})*p({<day = {'mon'}>})>}sales)

sunny_talwar — Thu, 30 Mar 2017 13:18:28 GMT

or this

Sum({<person = p({<day = {'sun'}>})*p({<day = {'mon'}>}), day = {'sun', 'mon'}>}sales)

somenathroy — Thu, 30 Mar 2017 13:21:27 GMT

Thanks Sunny.