topic Previous months average meeting the condition in QlikView https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903702#M1005085 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I want to take average of previous six months but after meeting the condition,</P><P></P><P><IMG __jive_id="87126" alt="qlik.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87126_qlik.png" style="height: 161px; width: 620px;" /></P><P></P><P>I have tried to achieve it but I am not getting the desired results, PFA is my excel and QVW file. Sheet1 contains the data and sheet2 describes what is needed to be achieved.</P><P></P><P>It is needed to be achieved on presentation only.</P><P></P><P>Best Regards,</P><P>Muhammad Raza</P></BODY></HTML> Thu, 21 May 2015 08:31:20 GMT muhammadraza 2015-05-21T08:31:20Z Previous months average meeting the condition https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903702#M1005085 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I want to take average of previous six months but after meeting the condition,</P><P></P><P><IMG __jive_id="87126" alt="qlik.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87126_qlik.png" style="height: 161px; width: 620px;" /></P><P></P><P>I have tried to achieve it but I am not getting the desired results, PFA is my excel and QVW file. Sheet1 contains the data and sheet2 describes what is needed to be achieved.</P><P></P><P>It is needed to be achieved on presentation only.</P><P></P><P>Best Regards,</P><P>Muhammad Raza</P></BODY></HTML> Thu, 21 May 2015 08:31:20 GMT https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903702#M1005085 muhammadraza 2015-05-21T08:31:20Z Re: Previous months average meeting the condition https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903703#M1005086 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 21 May 2015 12:33:55 GMT https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903703#M1005086 Gysbert_Wassenaar 2015-05-21T12:33:55Z Re: Previous months average meeting the condition https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903704#M1005087 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply but I cannot make any change into the datamodel, I have to achieve it through presentation.</P></BODY></HTML> Thu, 21 May 2015 12:45:53 GMT https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903704#M1005087 muhammadraza 2015-05-21T12:45:53Z Re: Previous months average meeting the condition https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903705#M1005088 <HTML><HEAD></HEAD><BODY><P>Then I very strongly recommend you use MS-Excel. Qlikview is <STRONG>not</STRONG> a spreadsheet program.</P></BODY></HTML> Thu, 21 May 2015 12:50:27 GMT https://community.qlik.com/t5/QlikView/Previous-months-average-meeting-the-condition/m-p/903705#M1005088 Gysbert_Wassenaar 2015-05-21T12:50:27Z