Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How do I colour certain sections on a line graph if dates are grouped by MonthStart?

Hi,

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).

Would it be possible to use an expression to colour certain date periods different colours?

I have used the following expression: if([Date_Comp_Raised] >= date(42234) and [Date_Comp_Raised] <= date(42447), rgb(96,162,80),black()). This works if the dates aren't grouped by 'MonthStart' but when they are the whole graph turns black.

Can anyone help me colour different dates ranges still using MonthStart?

Thanks in advance,

Paul

0 Replies