Need help by creating SQL Filter dataset ticker

[Tim_van_Rens]

Dear Community,

Please can you help me with creating a SQL filter regarding dataset ticker.
I have the following columns: ID, Weeknr, Name, Date.

The rows are as followed:
CURRENT WEEK–> Row 1: ID: 21, Week: 40, Name: , Date: 02-10-2023(Dutch time notation)
Row 2: ID: 21, Week: 41, Name: , Date: 02-10-2023(Dutch time notation)
Row 3: ID: 21, Week: 42, Name: , Date: 09-10-2023(Dutch time notation)
Row 4: ID: 21, Week: 43, Name: , Date: 16-10-2023(Dutch time notation)
Row 5: ID: 21, Week: 44, Name: , Date: 23-10-2023(Dutch time notation)

With following filter i can show current week:WEEK(Datum, 1) = WEEK(CURDATE())

What i want is creating a filter that shows the upcoming 4 weeks based on current weeknr.
So what i need is Weeknr from row 2-5 and name from row 2-5

Best Regards,

Tim

[Frazer]

Hi @Tim_van_Rens and welcome to the community!

You would use an advanced filter clause like so to achieve this:

Week = WEEK(CURDATE()) OR Week = WEEK(CURDATE())+1 OR Week = WEEK(CURDATE())+2 OR Week = WEEK(CURDATE())+3 OR Week = WEEK(CURDATE())+4

Kind Regards,

Frazer