Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BU
Partner - Contributor III
Partner - Contributor III

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)
1 Solution

Accepted Solutions
sunny_talwar

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
tresesco
MVP
MVP

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

Hello everyone!! Again.. 🙂

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

 

Ty so much

 

Ale

sunny_talwar

Give this a shot

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

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
Partner - Contributor III
Partner - Contributor III
Author

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

Now is more clear!

Thanks