Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Trend Lines in Line Chart like Microsoft Excel

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

Trend Line issue.PNG

4 Replies
qlikviewnovice
Specialist II
Specialist II

Hi

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

Hope it helps!!

subbareddykm
Creator II
Creator II
Author

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
Master II
Master II

see attached file

qlikviewnovice
Specialist II
Specialist II

Hi

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

Please find attached application.

Hope it helps!!