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 want to group the data on TransID & Department.
My Data is like this for TRSID1 & DEPT_A:
I want to show the output of Sales zero for those which the time is more than one year.
So out should be like this.
Please help me.
Thanks in advance.
May be this expression:
If(YearMonthNum <= Date(AddYears(Min(TOTAL <Department, Trans_Id> YearMonthNum), 1), 'YYYY-MM'), sum(Sales), 0)
Had to create YearMonthNum in the script because your YearMonth field was not a date field. Script (addition in red):
(ooxml, embedded labels, table is Sheet1);
Left Join (Data)
Date#(YearMonth, 'YYYY-MM') as YearMonthNum
View solution in original post