Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
CB308
Contributor III
Contributor III

Add Reference Line to Chart based on formula

I am trying to add Reference Lines to my Line Chart.

My chart is by Date, and I want to show a reference line on dates where the visit ended as in  my image below.

When I use formula If (Field = 1, %Date) nothing shows.

How do I display the date for the date the visit ended?

 

 

CB308_0-1635177519684.png

 

 

 

1 Reply
anthonyj
Creator III
Creator III

Hi @CB308 ,

The reference line needs to resolve to one value which your code may not be doing. If "Field = 1" is the condition for the allocation of the date, can I suggest:

max({$<Field={1}>}%Date)

I hope this helps.

Thanks

Anthony