Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 

Change Line Color based on Expression based on date dimension

I need to see if I can modify the color of the line in a line chart.  I have a dimension which is a date.  

I do a calculation of the difference between the Max Date and and average of another field.  I want the color of the line to be red prior to this cutoff and green after this cutoff.  The calculation is not a measure in my chart and I don't want it displayed.

For example my max date is 43894.  I subtract 2 from that and get 43892.  So all dates on the line prior to 43892 should be red and 43892 and later should be green.

I hope I explained that ok.

I have tried everything that I can think of and nothing has worked so far.

0 Replies