topic Previous Month in QlikView https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447217#M433569 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">hi, </SPAN></P><P><SPAN lang="en">i would like to calculate the percentage of previous months, my expression works for january, february, may but not for the rest of the months, attached app, i did not manage to identify the error you can m ' help please.</SPAN></P><P><SPAN lang="en">Best regards </SPAN></P><P><SPAN lang="en">Maurice <BR /></SPAN></P></BODY></HTML> Wed, 06 Sep 2017 15:45:08 GMT MauriceLudo 2017-09-06T15:45:08Z Previous Month https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447217#M433569 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">hi, </SPAN></P><P><SPAN lang="en">i would like to calculate the percentage of previous months, my expression works for january, february, may but not for the rest of the months, attached app, i did not manage to identify the error you can m ' help please.</SPAN></P><P><SPAN lang="en">Best regards </SPAN></P><P><SPAN lang="en">Maurice <BR /></SPAN></P></BODY></HTML> Wed, 06 Sep 2017 15:45:08 GMT https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447217#M433569 MauriceLudo 2017-09-06T15:45:08Z Re: Previous Month https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447218#M433570 <HTML><HEAD></HEAD><BODY><P>Maurice,</P><P></P><P>Maybe something like this :</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;"> ={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=Max(Month)-1)</EM></STRONG><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="font-size: 8pt;">&gt;} Sales) </SPAN></P></BODY></HTML> Wed, 06 Sep 2017 15:52:22 GMT https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447218#M433570 dmac1971 2017-09-06T15:52:22Z Re: Previous Month https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447219#M433571 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">it does not work, I have already tested, you have the application you can try</SPAN></P></BODY></HTML> Wed, 06 Sep 2017 16:02:36 GMT https://community.qlik.com/t5/QlikView/Previous-Month/m-p/1447219#M433571 MauriceLudo 2017-09-06T16:02:36Z