This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to calculate Sum(Sales) by quarters, excluding sales in last month each quarter.
The "to be" table should looks like this:
The table "as is" now look like this:
I can estimate MaxMonth in each row, but for Sum(Sales) expression it doesn't fit.
Expr. for maxMonth:
Expr. for Sales(no last month):
Is there any ideas?
=Sum(Aggr(If(DateReport <> Max(TOTAL <QuarterReport>DateReport), Sum(Sales)), QuarterReport, DateReport))
View solution in original post
Thanks, Sunny! It works