topic Re: Get next Saturday Date in QlikView

Get next Saturday Date

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

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.

For example: I select 11/15/2017 (Wednesday)> then I get 11/18/2017 (Saturday).

If I select 11/13/2017 (Monday)> then I get 11/18/2017 (Saturday).

If I select 11/19/2017 (Sunday)> then I get 11/25/2017 (Saturday).

Is there any way to do that?

Thank you!!!

sunny_talwar — Tue, 14 Nov 2017 15:41:31 GMT

Assuming you have this in the script

SET FirstWeekDay=6;

Try this

WeekEnd(Max(DateField))

Monicalingan — Tue, 14 Nov 2017 16:00:43 GMT

Used a text object to display the weekend and used the expression =WeekEnd(Date)

See attached.

Hope it helps.

Thanks,

Monica