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 have data as attached..I want this to pick Rolling 12 months..I want to pick rolling 12 month data..
Ex: From the below screenshot I want to pick data from 2017 - Mar to 2018 -Feb.
Next month when 2018 - Mar gets added I want to show data from 2017 - Apr to 2018 - Mar.
One possible way
year(MakeDate(Year)) as ExpenseYear,
month(MakeDate(2000,[Posting Period])) as ExpenseMonth,
Date(MakeDate(Year, [Posting Period]), 'YYYY-MMM') as ExpenseMonthYear
// year(MakeDate(Year)) & '-'& month(MakeDate(2000,[Posting Period])) as ExpenseMonthYear
(ooxml, embedded labels, table is Sheet1);
Right Join (Table)
LOAD MonthStart(ExpenseMonthYear, IterNo()) as ExpenseMonthYear
While IterNo() <= 12;
LOAD MonthStart(Max(ExpenseMonthYear), -12) as ExpenseMonthYear
View solution in original post
In the script?
yeah..if possible in where clause..
if not just filtering in the fields itself is ok too..
ypu are awesome.Thank you