Discussion Board for collaboration related to QlikView App Development.
Can one display in line chart 'actual vs estimate hrs' above one line only ?
Can someone suggest some techniques?
Waiting for your response.
Yes you can achieve this.
Create a separate expression to get your desired values.. and then uncheck the option for line or bar and check option for values on data point,
As you haven't provided sample data, I am creating a sample application to help.. You need to change accordingly.
Use below script
Load * Inline
Date, Actual Sales, Estimated Sales
01/01/2015, 100, 110
02/01/2015, 120, 90
03/01/2015, 75, 90
04/01/2015, 120, 120
Create a Line Chart
Dual(SUM([Actual Sales])&'/'&SUM([Estimated Sales]), SUM([Actual Sales]))
Hope this would help.
Thanks for the Response.