# 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

## 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

Labels (4)

• ### Set Analysis

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Intersection in Set Analysis

Give this a shot

``=Sum({<YEAR = {"\$(=Max(YEAR)-1)"}> * (<FIELD_1 = {'A'}, YEAR> + <FIELD_2 = {'B','D'}, YEAR>)} value)``
7 Replies
Highlighted
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

## 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

## Re: Intersection in Set Analysis

Hello everyone!! Again.. 🙂

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

Ty so much

Ale

Highlighted
MVP

## Re: Intersection in Set Analysis

Give this a shot

``=Sum({<YEAR = {"\$(=Max(YEAR)-1)"}> * (<FIELD_1 = {'A'}, YEAR> + <FIELD_2 = {'B','D'}, YEAR>)} value)``
Highlighted
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
MVP

## 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

## Re: Intersection in Set Analysis

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

Now is more clear!

Thanks