topic How do I colour certain sections on a line graph if dates are grouped by MonthStart? in App Development https://community.qlik.com/t5/App-Development/How-do-I-colour-certain-sections-on-a-line-graph-if-dates-are/m-p/1265563#M25904 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have built a line graph of Month Complaint Raised (X axis) against Number of Complaints (Y axis). The dimension for the graph is MonthStart([Date_Comp_Raised]) and the expression is count(Complaint_Number).</P><P></P><P>Would it be possible to use an expression to colour certain date periods different colours?</P><P></P><P>I have used the following expression: <SPAN style="text-decoration: underline;"><STRONG>if([Date_Comp_Raised] &gt;= date(42234) and [Date_Comp_Raised] &lt;= date(42447), rgb(96,162,80),black()).</STRONG></SPAN> This works if the dates aren't grouped by 'MonthStart' but when they are the whole graph turns black.</P><P></P><P>Can anyone help me colour different dates ranges still using MonthStart?</P><P></P><P>Thanks in advance,</P><P></P><P>Paul </P></BODY></HTML> Sat, 16 Nov 2024 10:06:49 GMT 2024-11-16T10:06:49Z How do I colour certain sections on a line graph if dates are grouped by MonthStart? https://community.qlik.com/t5/App-Development/How-do-I-colour-certain-sections-on-a-line-graph-if-dates-are/m-p/1265563#M25904 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have built a line graph of Month Complaint Raised (X axis) against Number of Complaints (Y axis). The dimension for the graph is MonthStart([Date_Comp_Raised]) and the expression is count(Complaint_Number).</P><P></P><P>Would it be possible to use an expression to colour certain date periods different colours?</P><P></P><P>I have used the following expression: <SPAN style="text-decoration: underline;"><STRONG>if([Date_Comp_Raised] &gt;= date(42234) and [Date_Comp_Raised] &lt;= date(42447), rgb(96,162,80),black()).</STRONG></SPAN> This works if the dates aren't grouped by 'MonthStart' but when they are the whole graph turns black.</P><P></P><P>Can anyone help me colour different dates ranges still using MonthStart?</P><P></P><P>Thanks in advance,</P><P></P><P>Paul </P></BODY></HTML> Sat, 16 Nov 2024 10:06:49 GMT https://community.qlik.com/t5/App-Development/How-do-I-colour-certain-sections-on-a-line-graph-if-dates-are/m-p/1265563#M25904 2024-11-16T10:06:49Z