topic Re: Set Analysis with Previous Month in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421365#M613662 <HTML><HEAD></HEAD><BODY><P>That turns the field to 0. </P></BODY></HTML> Thu, 14 Sep 2017 22:42:33 GMT 2017-09-14T22:42:33Z Set Analysis with Previous Month https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421363#M613660 <HTML><HEAD></HEAD><BODY><P>Please help!</P><P></P><P>I cannot get my set analysis to calculate correctly. The field&nbsp; <STRONG><EM>PM Fac Rept Bal</EM></STRONG>&nbsp; is</P><P><STRONG><EM>sum({$&lt;RecordYYYYMM ={'(=PrevYYYYMM&nbsp; )'}&gt;} Facility_Reportable_Bal_Amt)</EM></STRONG></P><P>but the results give the same field in <STRONG style="font-size: 13.3333px;"><EM>Facility_Reportable_Bal_Amt </EM></STRONG>and <STRONG style="font-size: 13.3333px;"> <STRONG style="font-size: 13.3333px;"><EM>PM Fac Rept Bal</EM></STRONG><SPAN style="font-size: 13.3333px;"> </SPAN></STRONG></P><P></P><P>As you can see when the record <STRONG><EM>RecordYYYYMM</EM></STRONG> = 201704 the <STRONG><EM>PM Fac Rept Bal </EM></STRONG></P><P>should be<STRONG> $97,284</STRONG></P><P><IMG alt="AprilBalance.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176667_AprilBalance.PNG" style="height: auto;" /></P><P><IMG alt="March Balance.PNG" class="jive-image image-2" src="/legacyfs/online/176668_March Balance.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 14 Sep 2017 22:31:27 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421363#M613660 2017-09-14T22:31:27Z Re: Set Analysis with Previous Month https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421364#M613661 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P>= <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;">sum({$&lt;RecordYYYYMM = </EM></STRONG><SPAN style="text-decoration: underline;"><EM style="font-weight: inherit; font-family: inherit;">{ "$(= PrevYYYYMM)" }</EM></SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM style="font-weight: inherit; font-family: inherit;"> &gt;} Facility_Reportable_Bal_Amt)</EM></STRONG></P></BODY></HTML> Thu, 14 Sep 2017 22:36:09 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421364#M613661 vishsaggi 2017-09-14T22:36:09Z Re: Set Analysis with Previous Month https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421365#M613662 <HTML><HEAD></HEAD><BODY><P>That turns the field to 0. </P></BODY></HTML> Thu, 14 Sep 2017 22:42:33 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421365#M613662 2017-09-14T22:42:33Z Re: Set Analysis with Previous Month https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421366#M613663 <HTML><HEAD></HEAD><BODY><P>‌can you share a sample to look into please?</P></BODY></HTML> Thu, 14 Sep 2017 23:09:07 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421366#M613663 vishsaggi 2017-09-14T23:09:07Z Re: Set Analysis with Previous Month https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421367#M613664 <HTML><HEAD></HEAD><BODY><P>Do you know how I can share proprietary data?</P></BODY></HTML> Tue, 19 Sep 2017 18:15:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421367#M613664 2017-09-19T18:15:28Z Re: Set Analysis with Previous Month https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421368#M613665 <HTML><HEAD></HEAD><BODY><P>Follow these instructions please:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Tue, 19 Sep 2017 18:37:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Previous-Month/m-p/1421368#M613665 vishsaggi 2017-09-19T18:37:04Z