Usage of SetAnalysis

[#1]

I am trying to make this statement work

=Max({$<[Calendar Year/Week]=Max(TOTAL [Calendar Year/Week])>}  Aggr( if($(vDE%LAG4BIBA)>1,1,$(vDE%LAG4BIBA)),[Calendar Year/Week],[Commercial Product]))

and it doesn't.

Can somebody check this statement and tell mme if I am making a typo mistake with >}...

The statement work when I am writting

=Max({$<[Calendar Year/Week]={201306}>}  Aggr( if($(vDE%LAG4BIBA)>1,1,$(vDE%LAG4BIBA)),[Calendar Year/Week],[Commercial Product]))

and it works when I remove the set analysis from the statement

Thanks in advance for your help

gilles

[Gysbert_Wassenaar]

Try:

Max({$<[Calendar Year/Week]={$(=Max(TOTAL [Calendar Year/Week]))} >}

[#3 · Accepted solution]

Thanks a lot for your answer

In fact I ended up with the following

Max({$<[Calendar Year/Week]={">=$(=Max(TOTAL [Calendar Year/Week],22))"}>}

Aggr( if($(vDE%LAG4BIBA)>1,1,$(vDE%LAG4BIBA)),[Calendar Year/Week],[Commercial Product]))

I found a nice SetAnalysis Generator at URL:

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Thanks Again

Gilles