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.
Can you help me filter the date in the script? I want the filters to give me only the numbers of the week until 2021 and 2020 is to be listed
Where (Year(MMT_MRPAccount.MRPDate) <= Year(Today())) and ( Week(MMT_MRPAccount.MRPDate) and (year(MMT_MRPAccount.MRPDate)=2021)) <= (Week(Today()) + WeekName(3));
It is scheduled to end on week 28
Hi Try like below
Where MMT_MRPAccount.MRPDate <=MakeWeekDate(Year(Today()),Week(Weekend(Today()+21)));
-- you can change based on ur requirement instead of this (Weekend(Today()+21)
View solution in original post
I was able to do what the code seemed to interest someone
expression >= AddMonths(Today(),-3)
Hi @MayilVahanan ,I have a similar problem, but now the other way around I have to narrow my search down to 3 months back from the current month.
MLL_Movements.Postingdate >= MakeWeekDate(Year(Today()),Month(Today()-105));