Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Give this a shot
=Sum({<YEAR = {"$(=Max(YEAR)-1)"}> * (<FIELD_1 = {'A'}, YEAR> + <FIELD_2 = {'B','D'}, YEAR>)} value)
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.
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
Hello everyone!! Again.. 🙂
i haven't found a solution yet. Any ideas?
Ty so much
Ale
Give this a shot
=Sum({<YEAR = {"$(=Max(YEAR)-1)"}> * (<FIELD_1 = {'A'}, YEAR> + <FIELD_2 = {'B','D'}, YEAR>)} value)
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
They are independent sets. The second set is still honoring selection in YEAR field which is what is causing the issue.
Aw ok.. Every set is indipendent to each other.
Now is more clear!
Thanks