topic Re: Delta Presentation in QlikView https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135194#M372691 <HTML><HEAD></HEAD><BODY><P>Search for 'Waterfall chart' here in the forum.</P><P></P><P>You can set a bar offset in your bar chart, so for example, create three expressions with no dimension in your chart</P><P></P><P>=Sum(Goal)</P><P>=Sum(Actual)</P><P>=Sum(Actual)-Sum(Goal)</P><P></P><P>open the bar offset attribute by clicking on the small + sign next to the third expression on expression tab.</P><P>Enter</P><P>=Sum(Goal) </P><P></P><P>as bar offset</P></BODY></HTML> Tue, 24 May 2016 14:52:04 GMT swuehl 2016-05-24T14:52:04Z Delta Presentation https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135193#M372690 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial, helvetica, sans-serif;">Hi, </SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">Is it possible to implement the attached chart on QV?</SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">Grey -<SPAN style="font-size: 14.6667px; color: #000000;">The total goal of activites </SPAN></SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">Green - <SPAN style="font-size: 14.6667px; color: #000000;">The actual amount of activities</SPAN></SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">Blue - Delta-&nbsp; </SPAN><SPAN style="color: #000000; font-size: 14.6667px; font-family: arial, helvetica, sans-serif;">The difference in number between the Goal and the Actual</SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: arial, helvetica, sans-serif;"><BR /></SPAN></P><P><SPAN><SPAN><SPAN style="color: #000000; font-size: 14.6667px;">(My problem is to display the Delta bar like on the attached file)</SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 24 May 2016 13:18:46 GMT https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135193#M372690 2016-05-24T13:18:46Z Re: Delta Presentation https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135194#M372691 <HTML><HEAD></HEAD><BODY><P>Search for 'Waterfall chart' here in the forum.</P><P></P><P>You can set a bar offset in your bar chart, so for example, create three expressions with no dimension in your chart</P><P></P><P>=Sum(Goal)</P><P>=Sum(Actual)</P><P>=Sum(Actual)-Sum(Goal)</P><P></P><P>open the bar offset attribute by clicking on the small + sign next to the third expression on expression tab.</P><P>Enter</P><P>=Sum(Goal) </P><P></P><P>as bar offset</P></BODY></HTML> Tue, 24 May 2016 14:52:04 GMT https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135194#M372691 swuehl 2016-05-24T14:52:04Z Re: Delta Presentation https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135195#M372692 <HTML><HEAD></HEAD><BODY><P>Thanks!!!!! works!</P></BODY></HTML> Tue, 24 May 2016 15:02:00 GMT https://community.qlik.com/t5/QlikView/Delta-Presentation/m-p/1135195#M372692 2016-05-24T15:02:00Z