Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try:
Max({$<[Calendar Year/Week]={$(=Max(TOTAL [Calendar Year/Week]))} >}
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