topic Re: How to create Water Fall Charts in QlikView https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120741#M369422 <HTML><HEAD></HEAD><BODY><P>No problem at all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Jul 2016 17:46:17 GMT sunny_talwar 2016-07-21T17:46:17Z How to create Water Fall Charts https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120736#M369417 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I Created 3 measures. I need to implement Water fall chart.</P><P><SPAN style="font-size: 12pt;">previous month Head count=</SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">Count</SPAN>({&lt;<SPAN style="color: #800000;">CDate</SPAN> = {'05/01/2016'}&gt;}<SPAN style="color: #0000ff;">DISTINCT</SPAN>(<SPAN style="color: #800000;">[Head_Count.Emp. Id]</SPAN>))&nbsp; </SPAN></P><P><SPAN style="font-size: 12pt;">Current Month New hires count=<SPAN style="color: #0000ff;">count</SPAN>({&lt;<SPAN style="color: #800000;">Newhires.CDate_NH</SPAN>={'&gt;=06/01/2016'}&gt;}<SPAN style="color: #800000;">[Newhires.Emp. Id]</SPAN>) </SPAN></P><P><SPAN><SPAN style="font-size: 12pt;">Current month Exit count=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN>({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">CDate</SPAN><SPAN> = {'06/01/2016'}&gt;}</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN>(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Head_Count.Emp. Id]</SPAN><SPAN>)) </SPAN></SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><SPAN style="font-size: 12pt;">Current month </SPAN>Head count= </SPAN></P><P><SPAN style="font-size: 12pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<SPAN style="font-size: 12pt;">previous month Head count</SPAN>+<SPAN style="font-size: 12pt;">Current Month New hires count-<SPAN style="font-size: 12pt;">Current month Exit count)</SPAN></SPAN></SPAN></P><P></P><P><SPAN style="font-size: 12pt;">1st Bar : <SPAN style="font-size: 12pt;">previous month Head count</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">2nd Bar : <SPAN style="font-size: 12pt;">Current Month New hires count</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">3rd Bar : <SPAN style="font-size: 12pt;">Current month Exit count</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;">4th Bar : <SPAN style="font-size: 12pt;"><SPAN style="font-size: 12pt;">Current month </SPAN>Head count</SPAN></SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">Please help me.</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Thanks,</SPAN></P><P><SPAN style="font-size: 12pt;">Kalyan Krishna</SPAN></P></BODY></HTML> Thu, 21 Jul 2016 17:26:31 GMT https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120736#M369417 Anonymous 2016-07-21T17:26:31Z Re: How to create Water Fall Charts https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120737#M369418 <HTML><HEAD></HEAD><BODY><P>You want something like this Kalyan?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132097_Capture.PNG" style="height: 205px; width: 620px;" /></P></BODY></HTML> Thu, 21 Jul 2016 17:33:19 GMT https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120737#M369418 sunny_talwar 2016-07-21T17:33:19Z Re: How to create Water Fall Charts https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120738#M369419 <HTML><HEAD></HEAD><BODY><P>Something like&nbsp; this?</P><P></P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132100_Capturar.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 21 Jul 2016 17:34:29 GMT https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120738#M369419 Clever_Anjos 2016-07-21T17:34:29Z Re: How to create Water Fall Charts https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120739#M369420 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Thu, 21 Jul 2016 17:44:14 GMT https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120739#M369420 Anonymous 2016-07-21T17:44:14Z Re: How to create Water Fall Charts https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120740#M369421 <HTML><HEAD></HEAD><BODY><P>Thanks Clever Anjos</P></BODY></HTML> Thu, 21 Jul 2016 17:45:08 GMT https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120740#M369421 Anonymous 2016-07-21T17:45:08Z Re: How to create Water Fall Charts https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120741#M369422 <HTML><HEAD></HEAD><BODY><P>No problem at all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 21 Jul 2016 17:46:17 GMT https://community.qlik.com/t5/QlikView/How-to-create-Water-Fall-Charts/m-p/1120741#M369422 sunny_talwar 2016-07-21T17:46:17Z