topic Draw total value in Line chart in QlikView

Draw total value in Line chart

Mon, 21 Sep 2009 11:58:52 GMT

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.

Draw total value in Line chart

Mon, 21 Sep 2009 17:42:53 GMT

Hi,

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

Thanks & Best Regards,

Kuldeep Tak

Draw total value in Line chart

Tue, 22 Sep 2009 16:06:29 GMT

Thanks for your answer.

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

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

Draw total value in Line chart

Tue, 22 Sep 2009 16:24:08 GMT

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.

Draw total value in Line chart

Tue, 22 Sep 2009 16:27:03 GMT

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

Draw total value in Line chart

Wed, 23 Sep 2009 06:36:11 GMT

Hey

I want to be sum each of tredlines.

So, I miss func ... qlkiview tredline

Thanks for every comment