creating calender which contains weekends of month... - Qlik Community

berryandcherry6 · ‎2016-08-06

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 · ‎2016-08-06

There is a qv function weekend()

Have you tried that?

maxgro · ‎2016-08-06

maybe

Weekend(yourdatefield)

Weekend(AddMonths(yourdatefield, -1))

berryandcherry6 · ‎2016-08-07

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 · ‎2016-08-07

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());

creating calender which contains weekends of months