Trend Lines in Line Chart like Microsoft Excel

[subbareddykm]

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

[Anonymous]

Hi

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

Hope it helps!!

[subbareddykm]

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

I tried but no luck

[Frank_Hartmann]

see attached file

[Anonymous]

Hi

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

Please find attached application.

Hope it helps!!