Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
clovati
Partner - Creator
Partner - Creator

Set Analysis instead of IF

Hi everybody!

I obtain what I want by IF but I would like to obtain it by SET ANALYSIS. (see attached Image please)

I tried these but it doesn't give any result:

sum({$<[%KEY_DEP]={"=[Data stato deposito]>=[Inizio_Mese]"}>} [_Flag apertura deposito])

or 

sum({$< [Data stato deposito]={"=[Data stato deposito]>=[Inizio_Mese]"}>} [_Flag apertura deposito])

Thank you in advance!

Cri

1 Solution

Accepted Solutions
stevejoyce
Specialist II
Specialist II

Set analysis doesn't evaluate at row level.  You should add a flag to your data model, example:

If([Data stato deposito] >= [Inizio_Mese], 1) as FlagName

 

Then your set analysis can do

sum({$< [FlagName]={1}>} [_Flag apertura deposito])

View solution in original post

1 Reply
stevejoyce
Specialist II
Specialist II

Set analysis doesn't evaluate at row level.  You should add a flag to your data model, example:

If([Data stato deposito] >= [Inizio_Mese], 1) as FlagName

 

Then your set analysis can do

sum({$< [FlagName]={1}>} [_Flag apertura deposito])