Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

In the expression ,I want to diplay on one line chart actual vs estimate work hours

Hi all,

Can one display in line chart 'actual vs estimate hrs' above one line only ?

Can someone suggest some techniques?

Waiting for your response.

Thanks

Geeta

3 Replies
sushil353
Master II
Master II

hi,

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,

HTH

Sushil

MK_QSL
MVP
MVP

Hi Geeta,

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

Dimension

Date

Expression

Dual(SUM([Actual Sales])&'/'&SUM([Estimated Sales]), SUM([Actual Sales]))

Hope this would help.

Anonymous
Not applicable
Author

Hi ,

Thanks for the Response.

Geeta