Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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