topic how to calculate... in QlikView https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154538#M520206 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Everyone, I have a problem about making a chart to calculate ...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Please see the attchment for sample,&nbsp; and I need to make a chart like this :</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136632_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp; How to?</P></BODY></HTML> Wed, 07 Sep 2016 02:59:38 GMT 2016-09-07T02:59:38Z how to calculate... https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154538#M520206 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Everyone, I have a problem about making a chart to calculate ...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Please see the attchment for sample,&nbsp; and I need to make a chart like this :</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136632_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp; How to?</P></BODY></HTML> Wed, 07 Sep 2016 02:59:38 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154538#M520206 2016-09-07T02:59:38Z Re: how to calculate... https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154539#M520207 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>t:</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID, Year, Level</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID001, 2014, A</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID002, 2014, B</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID003, 2014, C</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID001, 2015, B</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID002, 2015, C</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ID003, 2015, A</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>QUALIFY *;</STRONG></P><P><STRONG>UNQUALIFY ID;</STRONG></P><P></P><P><STRONG>t1:</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>Resident t;</STRONG></P><P></P><P>Pivot Table</P><P></P><P>Dimensions:</P><P><STRONG>t1.Year</STRONG></P><P><STRONG>t1.Level</STRONG></P><P><STRONG>Year</STRONG></P><P><STRONG>Level</STRONG></P><P></P><P>Expression:</P><P><STRONG>=Count(If(Year &gt; t1.Year, ID))</STRONG></P></BODY></HTML> Wed, 07 Sep 2016 03:45:22 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154539#M520207 sunny_talwar 2016-09-07T03:45:22Z Re: how to calculate... https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154540#M520208 <HTML><HEAD></HEAD><BODY><P>thanks a lot.&nbsp; That's what I'm looking for.</P></BODY></HTML> Wed, 07 Sep 2016 05:33:12 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/1154540#M520208 2016-09-07T05:33:12Z