Creating a total line from line chart

[#1]

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

[HirisH_V7]

Hi,

Check this,

If your Expression is,

• Sum(Actual_Demand)

Then create a second Expression like this,

• Sum(Total Actual_Demand)

HTH,

HirisH

[sunny_talwar]

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?

[HirisH_V7 · Accepted solution]

May be like this,

Dimensional limits ->

For Band Dimension -> Show total

HTH,

Hirish

[#5]

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

[rwunderlich]

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#7]

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

[rwunderlich]

The "correct" answer really should go to Hirish

-Rob