topic Re: upcoming weekday in QlikView

upcoming weekday

bhagi — Fri, 15 Nov 2024 23:49:09 GMT

Hi all,

I have a Listbox with dates, for example:

11/10/2017

11/11/2017

11/12/2017

11/13/2017

11/14/2017

11/15/2017

...

If I select any date, I need to know which is the next Saturday for that date

how to can i get this?

thanks

bhagi

Re: upcoming weekday

Vegar — Tue, 13 Oct 2020 05:01:42 GMT

You could solve this by set analysis.Assuming your date field is named [Date] and you have a field containing weekday names named [Weekday].

Only({<[Date] ={">$(=only([Date])) <= $(=only([Date])+6)"}, [Weekday] = {'Sat'}>}[Date])

Re: upcoming weekday

tresB — Tue, 13 Oct 2020 05:35:38 GMT

Or something like:

=Date(DateField+6-Num(Weekday(DateField)))

Assuming Monday is 1 (i.e. - FirstWeekDay=6)

Re: upcoming weekday

Chanty4u — Tue, 13 Oct 2020 08:25:41 GMT

why cant you try this?

SET FirstWeekDay=6;

=WeekEnd(Max(DateField))

Re: upcoming weekday

Brett_Bleess — Tue, 27 Oct 2020 15:43:39 GMT

@bhagi you have received three very good responses to your question on this one, we would greatly appreciate it if you would return to the thread and use the Accept as Solution button on the post(s) that helped you resolve things. If you did something different, you may post that and mark it after it is posted.

Regards,
Brett