Draw total value in Line chart

[#1]

Hello

I make line chart with two expressions ( called A, B )

And I need to summary A + B , append expression C.

But It's wrong calculations. I dont know why mistaken.

Sombody told me about it, please.

Best Regards.

[#2]

Hi,

In expression C, you can either write A+B or you can write column(1)+column(2).

Thanks & Best Regards,

Kuldeep Tak

[#3]

Thanks for your answer.

Already I had input expression C ( = A + B )

But , there are wrong... please, open attache file

[#4 · Accepted solution]

Actually your expression is correct. You can see that the real value of C is coming properly as a sum of A+B(Change your graph to a pivot table to verify). It is the trend line, which is not coming according to your expectations. Trendline won't come as a sum of other trendlines, i believe.

[#5]

Hi,

Uncheck all the trendlines for all expressions. you should get the results.

I dont understand why you have added member in the dimension. It seems that its the no of members on a particular date and the chrged amount.

I believe the trend should be based on time dimension instead of member.

Thanks & Best Regards,

Kuldeep Tak

[#6]

Hey

I want to be sum each of tredlines.

So, I miss func ... qlkiview tredline

Thanks for every comment