Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Identify Saturday's and Sunday's in graph and change colour

Hi guys - I have a date field 'Request_Date' which lists dates in format DD/MM/YYYY.  I use this to populate a standard bar graph.  Due to the nature of our business, the weekends are incredibly low and I'd like to try and 'visually' reduce the impact of the weekends on the graph.

How can I write some set analysis in my graph background colour to change the colour of the weekend bars?

I have a separate field called 'AD_Day' which lists the day of the week relating to request date but I need to show the graph using dimension 'Request_Date' to show a day by day demand analysis of our business.  Any ideas much appreciated.  Kind regards

Labels (5)
1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi 

in your chart expression 

go to background color and use this expression 

if(weekday(Request_Date)<5,blue(),red())

change the colors in the expressions to suite your need 

View solution in original post

2 Replies
lironbaram
Partner
Partner

hi 

in your chart expression 

go to background color and use this expression 

if(weekday(Request_Date)<5,blue(),red())

change the colors in the expressions to suite your need 

View solution in original post

jlampard40
Contributor III
Contributor III
Author

Thank you!