Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
somenathroy
Creator III
Creator III

Intersection within set analysis

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

a30
d22

Regards,

Som

1 Solution

Accepted Solutions
sunny_talwar

or this

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

View solution in original post

3 Replies
sunny_talwar

May be this

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

sunny_talwar

or this

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

somenathroy
Creator III
Creator III
Author

Thanks Sunny.