Discussion Board for collaboration related to QlikView App Development.
I have a bar chart with date as dimension and count(VAR) for expression. What I would like to do is using different color for Saturdays and Sundays.
I have SET DayNames='Mon;Tues;Wed;Thu;Fri;Sat;Sun';
Another technique is to grab the 'Sat' or 'Sun' from the date as follows:
right(Date (Date,'WWW'),3) ='Sat'
right(Date (Date,'WWW'),3) ='Sun'
View solution in original post
In expressions tab, expand the expression and set in Background Color:
If(weekday(DateField)>=5, Red(), Green())
Switch red and green for the colours you want.
Here I got Mondays and Tuesdays colored.
Thanks! I'll use this solution.
Cool. i rewrote it once or twice before posting and just realized it could be simplified a bit more:
Date (Date,'WWW') ='Sat'
Date (Date,'WWW') ='Sun'