topic Usage of SetAnalysis in QlikView

Usage of SetAnalysis

Thu, 04 Apr 2013 13:22:06 GMT

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

Re: Usage of SetAnalysis

Gysbert_Wassenaar — Thu, 04 Apr 2013 17:56:36 GMT

Try:

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

Re: Usage of SetAnalysis

Mon, 08 Apr 2013 10:51:22 GMT

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