topic Re: Add a trend line to a waterfall chart in QlikView https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879140#M306909 <HTML><HEAD></HEAD><BODY><P>here is the basic example of what I need just with the line as pictured above. in my real file, the expressions are true expressions and i'm struggling because there is no dimension for the line to go by. any expressions I put as a line show up as a dot.</P></BODY></HTML> Wed, 08 Apr 2015 18:24:30 GMT 2015-04-08T18:24:30Z Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879136#M306905 <HTML><HEAD></HEAD><BODY><P>I have a waterfall chart created from a bar chart with no dimensions. How do I add a trendline as shown in the following image?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/83128_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Apr 2015 18:00:19 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879136#M306905 2015-04-08T18:00:19Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879137#M306906 <HTML><HEAD></HEAD><BODY><P>How come the first two bars have the symbol &amp; line on top of them and the last three have them at the bottom?</P></BODY></HTML> Wed, 08 Apr 2015 18:05:05 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879137#M306906 sunny_talwar 2015-04-08T18:05:05Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879138#M306907 <HTML><HEAD></HEAD><BODY><P>the bars with the lines on the bottom are negative values. Perhaps this better explains why I want the lines (I just put in random numbers to illustrate - they are not to scale). the purpose is to follow values through a lifecycle.</P><P><IMG __jive_id="83135" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/83135_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 08 Apr 2015 18:09:31 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879138#M306907 2015-04-08T18:09:31Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879139#M306908 <HTML><HEAD></HEAD><BODY><P>I guess you can add it another expression. You will have to share a sample application for me to help you with it, without seeing the data it would be hard to figure what can be done.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 08 Apr 2015 18:13:14 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879139#M306908 sunny_talwar 2015-04-08T18:13:14Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879140#M306909 <HTML><HEAD></HEAD><BODY><P>here is the basic example of what I need just with the line as pictured above. in my real file, the expressions are true expressions and i'm struggling because there is no dimension for the line to go by. any expressions I put as a line show up as a dot.</P></BODY></HTML> Wed, 08 Apr 2015 18:24:30 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879140#M306909 2015-04-08T18:24:30Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879141#M306910 <HTML><HEAD></HEAD><BODY><P>I know you mentioned that you did not have a dimension, but what if we add one? Please review the attached document and see if this is helpful.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 08 Apr 2015 18:34:33 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879141#M306910 sunny_talwar 2015-04-08T18:34:33Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879142#M306911 <HTML><HEAD></HEAD><BODY><P>Beautiful thank you!!! I attempted to add a valuelist but I wasn't sure how to write the expression to it. Much appreciated!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 08 Apr 2015 19:05:31 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879142#M306911 2015-04-08T19:05:31Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879143#M306912 <HTML><HEAD></HEAD><BODY><P>Not a problem. There is an easier alternative to using the valuelist() function, which is inline table. Let me know if you would like to know aboue that alternative as well?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 08 Apr 2015 19:08:01 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879143#M306912 sunny_talwar 2015-04-08T19:08:01Z Re: Add a trend line to a waterfall chart https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879144#M306913 <HTML><HEAD></HEAD><BODY><P>I use inline tables in other areas of my dashboard so I am familiar with them. I didn't think of that but it makes sense. Thanks!</P></BODY></HTML> Wed, 08 Apr 2015 19:09:41 GMT https://community.qlik.com/t5/QlikView/Add-a-trend-line-to-a-waterfall-chart/m-p/879144#M306913 2015-04-08T19:09:41Z