Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

Intersection in Set Analysis

Hi everyones!! I've a doubt about the Set analysis intersection in QlikSense:

I've this expression:       = Sum( {<SET 1>  *  ( $( vSetAnalysis ) ) }  Sales)    

The expanded expression is:   = Sum( {<SET 1>  *  ( <SET2> + <SET3> ) }  Sales)     but it doesn't work. 

In QlikView I used ithis kind of logic and it worked. Can anyone help me?!

 

Ty So Much

Alex

1 Solution

Accepted Solutions
Highlighted

Re: Intersection in Set Analysis

Give this a shot

=Sum({<YEAR = {"$(=Max(YEAR)-1)"}> * (<FIELD_1 = {'A'}, YEAR> + <FIELD_2 = {'B','D'}, YEAR>)} value)

View solution in original post

7 Replies
Highlighted
MVP
MVP

Re: Intersection in Set Analysis

It should work in qlik sense as well. Can you elaborate on 'it doesn't work'? May be with a sample app/case to support your scenario.

Highlighted
Partner
Partner

Re: Intersection in Set Analysis

Ok, this is a good sample!!

 

in the attached app, if i select YEAR = 2020, in the KPI, i'm expecting 790 but the sum goes to 0... and i don't understand why! the intersection seems good.

 

ty!!

 

Alex

Highlighted
Partner
Partner

Re: Intersection in Set Analysis

Hello everyone!! Again.. 🙂

i haven't found a solution yet. Any ideas?

 

Ty so much

 

Ale

Highlighted

Re: Intersection in Set Analysis

Give this a shot

=Sum({<YEAR = {"$(=Max(YEAR)-1)"}> * (<FIELD_1 = {'A'}, YEAR> + <FIELD_2 = {'B','D'}, YEAR>)} value)

View solution in original post

Highlighted
Partner
Partner

Re: Intersection in Set Analysis

Mmmh I don't understand why the first set doesn't apply (YEAR = YEAR - 1) to the other sets but now it works!! 

TY a lot!!

 

Ale

Highlighted

Re: Intersection in Set Analysis

They are independent sets. The second set is still honoring selection in YEAR field which is what is causing the issue.

Highlighted
Partner
Partner

Re: Intersection in Set Analysis

Aw ok.. Every set is indipendent to each other.

Now is more clear!

Thanks