Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
geetaalhan
Contributor

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
Honored Contributor II

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

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

MVP
MVP

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

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
Contributor

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

Hi ,

Thanks for the Response.

Geeta