Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
QS21
Creator
Creator

Repeat one value (dot) across all dates (line)

In a qliksense line chart, x axis is oct 1 to oct31, dates of oct month.am displaying some actual balance as a line and have another predicted balance for end of month oct that 31st which is displayed as a dot on 31st. I need to show this dot as a flat line which has same value as 31 for all dates. 

Pls help!

2 Replies
Kushal_Chawda

@QS21  You can use reference line feature of line chart. Create a variable on front end for predicted balance as an below example

vPredictedBalance = sum(Predicted_balance)

You can now call this variable in reference line expression. See below

Kushal_Chawda_0-1728067814994.png

 

 

 

QS21
Creator
Creator
Author

I tried this but it is not showing any line. Not sure what the issue is. Logic wise it is correct.