topic Re: Date filter on year in QlikView

Date filter on year

Luke_Killer_IT — Tue, 22 Jun 2021 06:36:52 GMT

Hello,

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

Script:

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

Re: Date filter on year

MayilVahanan — Tue, 22 Jun 2021 10:24:41 GMT

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)

Re: Date filter on year

ElsieSmith — Wed, 23 Jun 2021 09:35:40 GMT

Select the Data tab, then click the Filter command. A drop-down arrow will appear in the header cell for each column. official site
Click the drop-down arrow for the column you want to filter.
The Filter menu will appear.
The worksheet will be filtered by the selected date filter.

Re: Date filter on year

Luke_Killer_IT — Thu, 01 Jul 2021 12:07:05 GMT

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.

my code:

MLL_Movements.Postingdate >= MakeWeekDate(Year(Today()),Month(Today()-105));

Re: Date filter on year

Luke_Killer_IT — Fri, 02 Jul 2021 06:30:02 GMT

Hi,

I was able to do what the code seemed to interest someone

Code:

expression >= AddMonths(Today(),-3)