Intersection in Set Analysis

[BU]

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

[tresesco]

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.

[BU]

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

[BU]

Hello everyone!! Again.. 🙂

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

Ty so much

Ale

[sunny_talwar · Accepted solution]

Give this a shot

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

[BU]

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

[sunny_talwar]

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

[BU]

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

Now is more clear!

Thanks