Quarter Refernce Lines

[brf10043]

I'm working on a Grid chart with the X dimension being a "Implementation Date".  The Implementation Date can be any date in 2017.  Is there a way to write an expression that draws reference lines to at the start or end of each quarter? 

[vishsaggi]

Hmm Strange it is not working as expected. Can you try like giving the S_Improv...Date in Reference line hardcoded for Q1.

Some reference here: Check it:

line riferences on grid chart | Qlik Community

[brf10043]

Not quite sure I understand what you mean

[brf10043]

I feel like I'm getting close.  I'm currently working on this expression.  I would have expected it to draw a line at the end of March, but it drew it and the first date on the chart

If(inquarter([S_Improvement Implemented Date], '30-Mar-2017', 0)='1',-1,0)

[sunny_talwar · Accepted solution]

Something like this?

[vishsaggi]

This is amazing. Thanks sunny for looking into this. Learnt something new. 🙂

[brf10043]

Sunny, that is perfect.  Thanks for your Help!  I can't seem to find the option to mark this as correct in the discussion.  I did mark it as Helpful though!

It is exactly what I need!