Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How do i add days of the week to my month calender and paint with other color to differentiate weekend from normal days of the week. Plz find attached.
Regards
The expression based off your date field which has day.month.year values would be like this
=WeekDay( date#(Date,'D.M.YYYY'))
to color based on a weekday or not , something like
if( only(WeekDay( date#(Date,'D.M.YYYY'))) ='Sat' or only(WeekDay( date#(Date,'D.M.YYYY')))='Sun', <weekendcolorexpression>, <weekdaycolorexpression>)
test data
Hi,
maybe like this?:
tabCalendar:
LOAD Date#(Date, 'DD.MM.YYYY') as Date,
// SubField(Date,'.',1) as Day,
// Subfield(Date,'.',2) as Month,
// Subfield(Date,'.',3) as Year,
Day(Date) as Day,
WeekDay(Date) as WeekDay,
Week(Date) as Week,
Month(Date) as Month,
QuarterName(Date) as QuarterYear,
Year(Date) as Year,
'Quarter '&ceil(month(Date)/3) as Quarter,
'Half ' & ceil(month(Date)/6) as HalfYear;
LOAD Date(date#(Date,'DD.MM.YYYY'),'DD/MM/YYYY') as Date
FROM [http://community.qlik.com/servlet/JiveServlet/download/594216-121488/Book11.xls]
(biff, embedded labels, table is Sheet1$);
hope this helps
regards
Marco
can you describe a bit more how it should look like?
maybe like this?:
hope this helps
regards
Marco
thanks.
Div(Day+WeekDay(MonthName)-1,7)
calculates the row number, i.e. days 1 to the first sunday are in the first row, the next 7 days in the second and so forth.
The Dual(' ', ...) part lets this numerical value be displayed as a blank character to hide it, I didn't want row numbers to occur.
regards
Marco
See
Qlikview Cookbook: Calendar Chart http://qlikviewcookbook.com/recipes/download-info/calendar-chart/