topic Re: creating calender which contains weekends of months in QlikView

creating calender which contains weekends of months

berryandcherry6 — Sat, 06 Aug 2016 15:59:33 GMT

Hi,

i need to create a calender which contains weekends of current month and previous month.

how could i do this.Please help me. Any help is appreciated.

Regards

settu_periasamy — Sat, 06 Aug 2016 17:02:22 GMT

There is a qv function weekend()

Have you tried that?

maxgro — Sat, 06 Aug 2016 19:03:57 GMT

maybe

Weekend(yourdatefield)

Weekend(AddMonths(yourdatefield, -1))

berryandcherry6 — Sun, 07 Aug 2016 13:27:47 GMT

Hi,

Thanks for reply

Above condition gives weekend of particular date.

But my requirement is if todays date is 07-08-2016, i want all the weekends that comes under this month. So i could use it for further purpose.

maxgro — Sun, 07 Aug 2016 17:29:28 GMT

weekend of today month and previous month

load

Distinct WeekEnd(date)

Where

WeekEnd(date) <= monthEnd(Today());

load

Date(AddMonths(MonthStart(Today()), -1) + IterNo() -1) as date

AutoGenerate 1

While

(AddMonths(MonthStart(Today()), -1) + IterNo() -1) <= MonthEnd(Today());