topic Re: Waterfall chart in QlikView https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164740#M898918 <HTML><HEAD></HEAD><BODY><P>Many thanks guys.... Apologies for the delayed reply as I fell sick. The file from Nimesh has answered my question.</P><P></P><P></P><P>Shafi</P></BODY></HTML> Tue, 09 Aug 2016 10:55:06 GMT ahammadshafi 2016-08-09T10:55:06Z Waterfall chart https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164737#M898915 <HTML><HEAD></HEAD><BODY><P>Dear Experts:</P><P></P><P>Please note, one of our clients have requested to create a chart in QV like the following, which they call "Waterfall Chart".</P><P></P><P><IMG alt="Waterfall chart.jpg" class="jive-image image-1" src="/legacyfs/online/132768_Waterfall chart.jpg" style="height: 256px; width: 620px;" /></P><P>I am concerned with the small chunks like "Operational changes/Additional services" or "Direct price reduction" where they start from top position of the right column. I never did anything like this before. </P><P></P><P>On the other hand the client didn't share any data with us. The data might be something like</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PTP</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PTC</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PTH</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>PTW</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Gross Price</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Gov. Mand. Discount</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Price after Gov. Control</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dir. Price Red.</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Ind. Rebate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Price b4 op. change</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>Op. Cha</STRONG><STRONG style="font-size: 10pt; line-height: 1.5em;">nges</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Net Price</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">68</TD><TD style="padding: 2px;">67</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">65</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">53</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">75</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">58</TD><TD style="padding: 2px;">75</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">73</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">61</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">59</TD></TR></TBODY></TABLE><P></P><P></P><P>Seeking your advice.</P><P></P><P></P><P>Ahammad Shafi</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164737#M898915 ahammadshafi 2020-11-25T16:16:04Z Re: Waterfall chart https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164738#M898916 <HTML><HEAD></HEAD><BODY><P>PFA.</P><P></P><P>Thanks,</P><P>Nimesh</P></BODY></HTML> Thu, 28 Jul 2016 05:56:31 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164738#M898916 Anonymous 2016-07-28T05:56:31Z Re: Waterfall chart https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164739#M898917 <HTML><HEAD></HEAD><BODY><P>Shafi,</P><P></P><P>Can you please post your Application</P></BODY></HTML> Thu, 28 Jul 2016 07:01:16 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164739#M898917 Anil_Babu_Samineni 2016-07-28T07:01:16Z Re: Waterfall chart https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164740#M898918 <HTML><HEAD></HEAD><BODY><P>Many thanks guys.... Apologies for the delayed reply as I fell sick. The file from Nimesh has answered my question.</P><P></P><P></P><P>Shafi</P></BODY></HTML> Tue, 09 Aug 2016 10:55:06 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164740#M898918 ahammadshafi 2016-08-09T10:55:06Z Re: Waterfall chart https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164741#M898919 <HTML><HEAD></HEAD><BODY><P>Hi Nimesh,</P><P>It wasn't clear at first that it was <SPAN style="font-size: 13.3333330154419px;">the bar offset in the Expressions that enabled this to work.</SPAN></P><P></P><P><IMG alt="Bar_off_set.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162192_Bar_off_set.JPG" style="height: auto;" /></P><P>Thanks</P></BODY></HTML> Thu, 04 May 2017 13:23:27 GMT https://community.qlik.com/t5/QlikView/Waterfall-chart/m-p/1164741#M898919 rob_greene 2017-05-04T13:23:27Z