Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
geetaalhan
Creator
Creator

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.

geetaalhan
Creator
Creator
Author

Hi ,

Thanks for the Response.

Geeta