This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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.