Discussion Board for collaboration on QlikView Scripting.
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.
There is a qv function weekend()
Have you tried that?
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.
weekend of today month and previous month
WeekEnd(date) <= monthEnd(Today());
Date(AddMonths(MonthStart(Today()), -1) + IterNo() -1) as date
(AddMonths(MonthStart(Today()), -1) + IterNo() -1) <= MonthEnd(Today());