topic Previous month value does not evaluating in QlikView https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428529#M512624 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have report as under</P><P></P><P>&nbsp; MY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep-2016&nbsp;&nbsp;&nbsp; Oct-2016&nbsp;&nbsp;&nbsp;&nbsp; Nov-2016</P><P>Score</P><P> S1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P> S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>The requirement is</P><P>&nbsp; MY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep-2016&nbsp;&nbsp;&nbsp; Oct-2016&nbsp;&nbsp;&nbsp;&nbsp; Nov-2016</P><P>Score</P><P> S1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Up&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dn</P><P> S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NC</P><P></P><P>I have used&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) - <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Max</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MY</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=chr(39) &amp; date(AddMonths(MY, -1), 'MMM-YYYY') &amp; chr(39))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) &gt; 0, '▲',<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) - <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">My</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=chr(39) &amp; date(AddMonths(MY, -1), 'MMM-YYYY') &amp; chr(39))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) &lt; 0, '▼'<BR /> , '')) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Please advise</SPAN></P><P><SPAN style="font-size: 8pt;">Thanks</SPAN></P></BODY></HTML> Tue, 10 Oct 2017 18:21:19 GMT Anonymous 2017-10-10T18:21:19Z Previous month value does not evaluating https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428529#M512624 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have report as under</P><P></P><P>&nbsp; MY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep-2016&nbsp;&nbsp;&nbsp; Oct-2016&nbsp;&nbsp;&nbsp;&nbsp; Nov-2016</P><P>Score</P><P> S1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P> S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>The requirement is</P><P>&nbsp; MY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep-2016&nbsp;&nbsp;&nbsp; Oct-2016&nbsp;&nbsp;&nbsp;&nbsp; Nov-2016</P><P>Score</P><P> S1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Up&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dn</P><P> S2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NC</P><P></P><P>I have used&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) - <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Max</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">MY</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=chr(39) &amp; date(AddMonths(MY, -1), 'MMM-YYYY') &amp; chr(39))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) &gt; 0, '▲',<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) - <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">max</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">My</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(=chr(39) &amp; date(AddMonths(MY, -1), 'MMM-YYYY') &amp; chr(39))</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">RAG</SPAN><SPAN style="font-size: 8pt;">) &lt; 0, '▼'<BR /> , '')) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Please advise</SPAN></P><P><SPAN style="font-size: 8pt;">Thanks</SPAN></P></BODY></HTML> Tue, 10 Oct 2017 18:21:19 GMT https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428529#M512624 Anonymous 2017-10-10T18:21:19Z Re: Previous month value does not evaluating https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428530#M512625 <HTML><HEAD></HEAD><BODY><P>Is this in a pivot table? May be use Before() function...</P></BODY></HTML> Tue, 10 Oct 2017 18:23:01 GMT https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428530#M512625 sunny_talwar 2017-10-10T18:23:01Z Re: Previous month value does not evaluating https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428531#M512626 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>It does not work</P><P></P><P>n short the requirements is</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179154_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Current-Previous and display arrow in current cell</P><P>Thanks</P></BODY></HTML> Tue, 10 Oct 2017 18:48:02 GMT https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428531#M512626 Anonymous 2017-10-10T18:48:02Z Re: Previous month value does not evaluating https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428532#M512627 <HTML><HEAD></HEAD><BODY><P>I need as below</P><P>Thanks Sunny<IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179155_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 10 Oct 2017 18:54:43 GMT https://community.qlik.com/t5/QlikView/Previous-month-value-does-not-evaluating/m-p/1428532#M512627 Anonymous 2017-10-10T18:54:43Z