topic Re: Trend Lines in Line Chart like Microsoft Excel in QlikView

Trend Lines in Line Chart like Microsoft Excel

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a requirement , where i have to create trend lines in Line chart like we do in Microsoft excel.

Let me explain in breif,

I have Two sales columns and ID. My dimention is ID exp are Sum(Sales) and sum(Sales2).

Now i need to create trend lines like we do in excel.

In Excel :

If i right click on any line in excel , i can see Trendline Option and if select that it is automatically creating one line like for the same can we have any option in qlikview or How to build logic to achieve the same line in qlikview Like below.

Please help on the same

Re: Trend Lines in Line Chart like Microsoft Excel

Anonymous — Tue, 30 May 2017 10:01:43 GMT

Right Click Chart Properties>Presentation Tab>Reference Lines>Add Trend line with your expression

Hope it helps!!

Re: Trend Lines in Line Chart like Microsoft Excel

subbareddykm — Tue, 30 May 2017 10:19:16 GMT

Can you try on my data and please confirm whether you are able to get it or not .

I tried but no luck

Re: Trend Lines in Line Chart like Microsoft Excel

Frank_Hartmann — Tue, 30 May 2017 10:27:08 GMT

see attached file

Re: Trend Lines in Line Chart like Microsoft Excel

Anonymous — Tue, 30 May 2017 10:32:53 GMT

Right Click Chart Properties>Expression tab>Trendlines>Opt Linear

Please find attached application.

Hope it helps!!