topic Re: Creating a total line from line chart in QlikView

Creating a total line from line chart

Wed, 17 Feb 2016 08:43:57 GMT

Hi,

anyone able to assist with the creation of a 'Total line'

<Band> is a dimension - the current line chart that I have is as per below.

I need to have another line that will show the total of these values as the dotted line that I have drawn out

thank you

Re: Creating a total line from line chart

HirisH_V7 — Wed, 17 Feb 2016 13:59:19 GMT

Hi,

Check this,

If your Expression is,

Sum(Actual_Demand)

Then create a second Expression like this,

Sum(Total Actual_Demand)

HTH,

HirisH

Re: Creating a total line from line chart

sunny_talwar — Wed, 17 Feb 2016 14:16:17 GMT

I think creating a second expression would be a problem as it would remove the effect of second dimension. Do you have a sample you can share so that we can help you better?

Re: Creating a total line from line chart

HirisH_V7 — Wed, 17 Feb 2016 14:24:59 GMT

May be like this,

Dimensional limits ->

For Band Dimension -> Show total

HTH,

Hirish

Re: Creating a total line from line chart

Wed, 17 Feb 2016 23:52:11 GMT

Hi Sunny,

You are right, when I add another expression, it messes with the first dimension

when selecting the 'Band Dimension' <Show Total>, it is only represented as 1 figure at the end of the line chart but not a line in itself.

I was thinking the expression should be the values of the selections from the field or something as such

thanks

Re: Creating a total line from line chart

rwunderlich — Thu, 18 Feb 2016 01:30:14 GMT

Hirish's suggestion of "Show Total" for Band works for me. Can you upload a small sample?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Creating a total line from line chart

Thu, 18 Feb 2016 02:38:11 GMT

Hi,

thank you so much. I had selected the Total at the Month initially. after selecting the total at BAND, the Total line is accurately displayed.

regards,

grace

Re: Creating a total line from line chart

rwunderlich — Thu, 18 Feb 2016 16:21:55 GMT

The "correct" answer really should go to Hirish

-Rob