topic Re: ONE linear trendline, for bar chart in QlikView

ONE linear trendline, for bar chart

Wed, 17 Sep 2014 07:27:54 GMT

Is it possible to have one linear trendline, for a bar chart with 3 dimensions?

If I tick the 'Linear' box i get a trendline for each value, which I do not want. I only want one one trendline for the total

The only way I can see to do this is to remove the 3rd dimension, but i do not want to do this!

How can i retain the stacked bar chart and also only have one trendline for the total?

My expression is very simple:

=SUM(Revenue/1000)

Re: ONE linear trendline, for bar chart

rubenmarin — Wed, 17 Sep 2014 07:51:45 GMT

You can try to create an expression, unchecking 'Bar' and checking 'Values on data', in this expression is where you have to check the linear trendline.

The expression should be something like:

Sum(TOTAL <Week> Revenue/1000)

Re: ONE linear trendline, for bar chart

Wed, 17 Sep 2014 08:12:13 GMT

I get the error message 'Drawing of chart failed internally' when I tried to do this

Re: ONE linear trendline, for bar chart

Wed, 17 Sep 2014 08:14:45 GMT

Is it possible to use a Reference Line? I can't figure out what the formula would be though

Re: ONE linear trendline, for bar chart

rubenmarin — Wed, 17 Sep 2014 08:15:45 GMT

I have done this with 2 dimensions, I added one more dimension to my graph and still draws it.

Can you upload a sample?

Re: ONE linear trendline, for bar chart

Wed, 17 Sep 2014 08:21:49 GMT

i used the wrong 'week' field

it worked! thanks so much