topic Re: Linear trendline not affect by secondary dimension? in QlikView

Linear trendline not affect by secondary dimension?

Fri, 11 Jul 2014 14:44:34 GMT

Is it possible to add trendlines which are not affected by a secondary dimension?

As you can see the chart below shows 4 trendlines. I just want one for the total though!

Re: Linear trendline not affect by secondary dimension?

Gysbert_Wassenaar — Fri, 11 Jul 2014 14:54:40 GMT

Probably easiest to create a new chart with only the month dimension and add the trendline in that chart and put it on top of the original chart. Make a copy of the first, remove the secondary dimension and add the trendline. Next set the remaining expression to invisible and the background of the chart to 100% transparant. See attached example.

Re: Linear trendline not affect by secondary dimension?

Fri, 11 Jul 2014 14:57:47 GMT

Unfortunately i need the trendline to appear when my users click on the 'Copy Image to Clipboard' icon. SO i don't think that method would work, woudl it?

Re: Linear trendline not affect by secondary dimension?

Gysbert_Wassenaar — Fri, 11 Jul 2014 15:34:10 GMT

Yes, it wouldn't. The only alternative I can think of that might work is a combichart with only one dimension and an expression for each value of what's now your second dimension and an expression for the trendline using the linest_m and linest_b functions.

Re: Linear trendline not affect by secondary dimension?

Wed, 17 Sep 2014 08:27:27 GMT

I found the answer to this elsewhere

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)