topic MONTH WISE VALUE in QlikView

topic MONTH WISE VALUE in QlikView https://community.qlik.com/t5/QlikView/MONTH-WISE-VALUE/m-p/1256861#M851262 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>i want to get a last 03  month value  not add month field to chart. (WITHIN TWO YEARS TURNING POINT)</P><P>I WANT BELOW</P><P></P><H2>JAN 2017 = VALUE</H2><H2>DEC 2016 VALUE</H2><H2>NOV 2016= VALUE</H2><P></P><P><SPAN style="color: #ff0000;">NOT USING BELOW</SPAN> </P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="475"><TBODY><TR><TD class="xl63" height="17" style="border: 0px solid black;" width="50"> </TD><TD class="xl64" style="border: 0px solid black; border-left: none;" width="98">YEAR</TD><TD class="xl65" style="border: 0px solid black; border-left: none;" width="109">2016</TD><TD class="xl65" style="border: 0px solid black; border-left: none;" width="109">2016</TD><TD class="xl65" style="border: 0px solid black; border-left: none;" width="109">2017</TD></TR><TR><TD class="xl66" height="17" style="border: 0px solid black; border-top: none;">BCOD</TD><TD class="xl67" style="border: 0px solid black; border-top: none;">MONTH</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">11</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">12</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">1</TD></TR><TR><TD class="xl68" height="17" style="border: 0px solid black; border-top: none;">CO01</TD><TD class="xl69" style="border: 0px solid black;"> </TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">26,315,373</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">22,448,666</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">21,284,113</TD></TR><TR><TD class="xl68" height="17" style="border: 0px solid black; border-top: none;">CO02</TD><TD class="xl69" style="border: 0px solid black; border-top: none;"> </TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">3,085,912</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">1,867,994</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">4,292,186</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>I using given below expression</P><P></P><H1><SPAN style="color: #993366;">FIRSTLY I SELECT JAN 2017</SPAN></H1><P></P><P></P><H2>01.  2017 JAN (CURENT MONTH) =  <SPAN style="color: #ff9900;">Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS ALREADY WORK</SPAN><BR /></SPAN></H2><P><SPAN style="color: #ff9900;"><BR /></SPAN></P><H2><SPAN style="color: #ff9900;"><SPAN style="color: #000000;">02.  2016 DEC</SPAN> = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  <SPAN style="color: #ff0000;">THIS IS COME TO ZERO VALUE </SPAN></SPAN></H2><H2><SPAN style="color: #000000;"><BR /></SPAN></H2><H2><SPAN style="color: #ff0000;"><SPAN style="color: #000000;">03.  2016 NOV</SPAN> <SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS A WORK</SPAN></SPAN></H2><P><SPAN style="color: #ff9900;"><BR /></SPAN></P><H1><SPAN style="color: #993366;"><BR /></SPAN></H1><H1><SPAN style="color: #993366;"><BR /></SPAN></H1><H1><SPAN style="color: #993366;">SECONDARY I SELECT FEB  2017</SPAN></H1><P><SPAN style="color: #993366;"><BR /></SPAN></P><H2>01.  2017 FEB (CURENT MONTH) =  <SPAN style="color: #ff9900;">Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS ALREADY WORK</SPAN><BR /></SPAN></H2><H2><SPAN style="color: #ff9900;"><BR /></SPAN></H2><H2><SPAN style="color: #ff9900;"><SPAN style="color: #000000;">02.  2016 JAN</SPAN> = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  <SPAN style="color: #ff0000;"><SPAN style="color: #ff9900;"> <SPAN style="color: #ff0000;">THIS IS A WORK</SPAN></SPAN> <BR /></SPAN></SPAN></H2><H2><SPAN style="color: #000000;"><BR /></SPAN></H2><H2><SPAN style="color: #ff0000;"><SPAN style="color: #000000;">03.  2016 DEC</SPAN> <SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS IS COME TO 2015 DEC VALUE <BR /></SPAN><BR /></SPAN></SPAN></H2><P><SPAN style="color: #000000;">I USING INPUT BOX IT IS GIVEN BELOW</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="280"><TBODY><TR><TD class="xl63" height="17" style="border: 0px solid black;" width="115">vMaxdate</TD><TD class="xl63" style="border: 0px solid black;" width="14">=</TD><TD class="xl63" style="border: 0px solid black;" width="151">01 Jan 2017</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonthYear</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">2016</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vMindate</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">01 Jan 2017</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">prioryear</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">2016</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vMaxDay</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">31</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Dec</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-1</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Nov</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-2</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Oct</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-3</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Sep</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-4</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Aug</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-5</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Jul</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-6</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Jun</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-7</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">May</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-8</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Apr</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-9</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Mar</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-10</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Feb</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-11</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Jan</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-12</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Dec</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-13</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Nov</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vNextMonth</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Feb</TD></TR></TBODY></TABLE><P><SPAN style="color: #ff9900;"><BR /></SPAN></P><P>PLEASE HELP ME</P><P></P><P>SAGARA</P><P></P><DIV style="display: none;"> </DIV><DIV> </DIV></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sagaraperera 2020-11-25T16:16:04Z MONTH WISE VALUE https://community.qlik.com/t5/QlikView/MONTH-WISE-VALUE/m-p/1256861#M851262 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>i want to get a last 03  month value  not add month field to chart. (WITHIN TWO YEARS TURNING POINT)</P><P>I WANT BELOW</P><P></P><H2>JAN 2017 = VALUE</H2><H2>DEC 2016 VALUE</H2><H2>NOV 2016= VALUE</H2><P></P><P><SPAN style="color: #ff0000;">NOT USING BELOW</SPAN> </P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="475"><TBODY><TR><TD class="xl63" height="17" style="border: 0px solid black;" width="50"> </TD><TD class="xl64" style="border: 0px solid black; border-left: none;" width="98">YEAR</TD><TD class="xl65" style="border: 0px solid black; border-left: none;" width="109">2016</TD><TD class="xl65" style="border: 0px solid black; border-left: none;" width="109">2016</TD><TD class="xl65" style="border: 0px solid black; border-left: none;" width="109">2017</TD></TR><TR><TD class="xl66" height="17" style="border: 0px solid black; border-top: none;">BCOD</TD><TD class="xl67" style="border: 0px solid black; border-top: none;">MONTH</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">11</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">12</TD><TD class="xl65" style="border: 0px solid black; border-left: none; border-top: none;">1</TD></TR><TR><TD class="xl68" height="17" style="border: 0px solid black; border-top: none;">CO01</TD><TD class="xl69" style="border: 0px solid black;"> </TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">26,315,373</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">22,448,666</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">21,284,113</TD></TR><TR><TD class="xl68" height="17" style="border: 0px solid black; border-top: none;">CO02</TD><TD class="xl69" style="border: 0px solid black; border-top: none;"> </TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">3,085,912</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">1,867,994</TD><TD align="right" class="xl70" style="border: 0px solid black; border-left: none; border-top: none;">4,292,186</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>I using given below expression</P><P></P><H1><SPAN style="color: #993366;">FIRSTLY I SELECT JAN 2017</SPAN></H1><P></P><P></P><H2>01.  2017 JAN (CURENT MONTH) =  <SPAN style="color: #ff9900;">Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS ALREADY WORK</SPAN><BR /></SPAN></H2><P><SPAN style="color: #ff9900;"><BR /></SPAN></P><H2><SPAN style="color: #ff9900;"><SPAN style="color: #000000;">02.  2016 DEC</SPAN> = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  <SPAN style="color: #ff0000;">THIS IS COME TO ZERO VALUE </SPAN></SPAN></H2><H2><SPAN style="color: #000000;"><BR /></SPAN></H2><H2><SPAN style="color: #ff0000;"><SPAN style="color: #000000;">03.  2016 NOV</SPAN> <SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS A WORK</SPAN></SPAN></H2><P><SPAN style="color: #ff9900;"><BR /></SPAN></P><H1><SPAN style="color: #993366;"><BR /></SPAN></H1><H1><SPAN style="color: #993366;"><BR /></SPAN></H1><H1><SPAN style="color: #993366;">SECONDARY I SELECT FEB  2017</SPAN></H1><P><SPAN style="color: #993366;"><BR /></SPAN></P><H2>01.  2017 FEB (CURENT MONTH) =  <SPAN style="color: #ff9900;">Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS ALREADY WORK</SPAN><BR /></SPAN></H2><H2><SPAN style="color: #ff9900;"><BR /></SPAN></H2><H2><SPAN style="color: #ff9900;"><SPAN style="color: #000000;">02.  2016 JAN</SPAN> = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  <SPAN style="color: #ff0000;"><SPAN style="color: #ff9900;"> <SPAN style="color: #ff0000;">THIS IS A WORK</SPAN></SPAN> <BR /></SPAN></SPAN></H2><H2><SPAN style="color: #000000;"><BR /></SPAN></H2><H2><SPAN style="color: #ff0000;"><SPAN style="color: #000000;">03.  2016 DEC</SPAN> <SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS IS COME TO 2015 DEC VALUE <BR /></SPAN><BR /></SPAN></SPAN></H2><P><SPAN style="color: #000000;">I USING INPUT BOX IT IS GIVEN BELOW</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="280"><TBODY><TR><TD class="xl63" height="17" style="border: 0px solid black;" width="115">vMaxdate</TD><TD class="xl63" style="border: 0px solid black;" width="14">=</TD><TD class="xl63" style="border: 0px solid black;" width="151">01 Jan 2017</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonthYear</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">2016</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vMindate</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">01 Jan 2017</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">prioryear</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">2016</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vMaxDay</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">31</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Dec</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-1</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Nov</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-2</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Oct</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-3</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Sep</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-4</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Aug</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-5</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Jul</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-6</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Jun</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-7</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">May</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-8</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Apr</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-9</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Mar</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-10</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Feb</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-11</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Jan</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-12</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Dec</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vPriorMonth-13</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Nov</TD></TR><TR><TD class="xl63" height="17" style="border: 0px solid black;">vNextMonth</TD><TD class="xl63" style="border: 0px solid black;">=</TD><TD class="xl63" style="border: 0px solid black;">Feb</TD></TR></TBODY></TABLE><P><SPAN style="color: #ff9900;"><BR /></SPAN></P><P>PLEASE HELP ME</P><P></P><P>SAGARA</P><P></P><DIV style="display: none;"> </DIV><DIV> </DIV></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/MONTH-WISE-VALUE/m-p/1256861#M851262 sagaraperera 2020-11-25T16:16:04Z