Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Right Click Chart Properties>Presentation Tab>Reference Lines>Add Trend line with your expression
Hope it helps!!
Can you try on my data and please confirm whether you are able to get it or not .
I tried but no luck
see attached file
Hi
Right Click Chart Properties>Expression tab>Trendlines>Opt Linear
Please find attached application.
Hope it helps!!