topic Re: month wise VALUE in QlikView

topic Re: month wise VALUE in QlikView https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256766#M851316 <HTML><HEAD></HEAD><BODY><P>USING THIS </P><H2><SPAN style="color: #ff9900;">= SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  <SPAN style="color: #ff0000;">THIS IS COME TO ZERO VALUE </SPAN></SPAN></H2><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155698_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P></P><P>SECOND SELECTION - IT COME TO</P><P></P><H2><SPAN style="color: #ff0000;"> <SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS IS OK VALUE (209,252,151)<BR /></SPAN></SPAN></SPAN></H2><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/155700_pastedImage_10.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;">THEN I USE SAME EXPRESSION </SPAN></P><H2><SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THISCOME TO JAN 2015 VALUE (301,036,534)<BR /></SPAN></SPAN></H2><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/155699_pastedImage_9.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P>VALUE 301036534 IS A 2015 JAN VALUE</P><P></P><P></P><P>PLEASE HELP</P><P></P><DIV style="display: none;"> </DIV><DIV> </DIV></BODY></HTML> Thu, 09 Mar 2017 06:53:04 GMT sagaraperera 2017-03-09T06:53:04Z month wise VALUE https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256763#M851313 <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><H2></H2><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" width="50"> </TD><TD class="xl64" style="border-left: none;" width="98">YEAR</TD><TD class="xl65" style="border-left: none;" width="109">2016</TD><TD class="xl65" style="border-left: none;" width="109">2016</TD><TD class="xl65" style="border-left: none;" width="109">2017</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">BCOD</TD><TD class="xl67" style="border-top: none;">MONTH</TD><TD class="xl65" style="border-top: none; border-left: none;">11</TD><TD class="xl65" style="border-top: none; border-left: none;">12</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">CO01</TD><TD class="xl69"> </TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">26,315,373</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">22,448,666</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">21,284,113</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">CO02</TD><TD class="xl69" style="border-top: none;"> </TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">3,085,912</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">1,867,994</TD><TD align="right" class="xl70" style="border-top: none; border-left: 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" width="115">vMaxdate</TD><TD class="xl63" width="14">=</TD><TD class="xl63" width="151">01 Jan 2017</TD></TR><TR><TD class="xl63" height="17">vPriorMonthYear</TD><TD class="xl63">=</TD><TD class="xl63">2016</TD></TR><TR><TD class="xl63" height="17">vMindate</TD><TD class="xl63">=</TD><TD class="xl63">01 Jan 2017</TD></TR><TR><TD class="xl63" height="17">prioryear</TD><TD class="xl63">=</TD><TD class="xl63">2016</TD></TR><TR><TD class="xl63" height="17">vMaxDay</TD><TD class="xl63">=</TD><TD class="xl63">31</TD></TR><TR><TD class="xl63" height="17">vPriorMonth</TD><TD class="xl63">=</TD><TD class="xl63">Dec</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-1</TD><TD class="xl63">=</TD><TD class="xl63">Nov</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-2</TD><TD class="xl63">=</TD><TD class="xl63">Oct</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-3</TD><TD class="xl63">=</TD><TD class="xl63">Sep</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-4</TD><TD class="xl63">=</TD><TD class="xl63">Aug</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-5</TD><TD class="xl63">=</TD><TD class="xl63">Jul</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-6</TD><TD class="xl63">=</TD><TD class="xl63">Jun</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-7</TD><TD class="xl63">=</TD><TD class="xl63">May</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-8</TD><TD class="xl63">=</TD><TD class="xl63">Apr</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-9</TD><TD class="xl63">=</TD><TD class="xl63">Mar</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-10</TD><TD class="xl63">=</TD><TD class="xl63">Feb</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-11</TD><TD class="xl63">=</TD><TD class="xl63">Jan</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-12</TD><TD class="xl63">=</TD><TD class="xl63">Dec</TD></TR><TR><TD class="xl63" height="17">vPriorMonth-13</TD><TD class="xl63">=</TD><TD class="xl63">Nov</TD></TR><TR><TD class="xl63" height="17">vNextMonth</TD><TD class="xl63">=</TD><TD class="xl63">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><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/1256763#M851313 sagaraperera 2020-11-25T16:16:04Z Re: month wise VALUE https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256764#M851314 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Can U share sample application on the same </P></BODY></HTML> Thu, 09 Mar 2017 06:31:39 GMT https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256764#M851314 nagarjuna_kotha 2017-03-09T06:31:39Z Re: month wise VALUE https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256765#M851315 <HTML><HEAD></HEAD><BODY><P>It will be easier to solve issue...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P></P><P>-Nagarjun</P></BODY></HTML> Thu, 09 Mar 2017 06:33:46 GMT https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256765#M851315 nagarjuna_kotha 2017-03-09T06:33:46Z Re: month wise VALUE https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256766#M851316 <HTML><HEAD></HEAD><BODY><P>USING THIS </P><H2><SPAN style="color: #ff9900;">= SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual])  <SPAN style="color: #ff0000;">THIS IS COME TO ZERO VALUE </SPAN></SPAN></H2><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155698_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P></P><P>SECOND SELECTION - IT COME TO</P><P></P><H2><SPAN style="color: #ff0000;"> <SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THIS IS OK VALUE (209,252,151)<BR /></SPAN></SPAN></SPAN></H2><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/155700_pastedImage_10.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;">THEN I USE SAME EXPRESSION </SPAN></P><H2><SPAN style="color: #ff9900;">=SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) <SPAN style="color: #ff0000;">THISCOME TO JAN 2015 VALUE (301,036,534)<BR /></SPAN></SPAN></H2><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/155699_pastedImage_9.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P>VALUE 301036534 IS A 2015 JAN VALUE</P><P></P><P></P><P>PLEASE HELP</P><P></P><DIV style="display: none;"> </DIV><DIV> </DIV></BODY></HTML> Thu, 09 Mar 2017 06:53:04 GMT https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256766#M851316 sagaraperera 2017-03-09T06:53:04Z Re: month wise VALUE https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256767#M851317 <HTML><HEAD></HEAD><BODY><P>Hi Perera,</P><P></P><P>FYI,</P><P></P><P>Follow these links to upload a sample qvw.</P><P></P><UL><LI><A href="https://community.qlik.com/docs/DOC-16454">Uploading a Sample</A></LI><LI><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></LI></UL><P></P><P></P><P>-Ganesh</P></BODY></HTML> Thu, 09 Mar 2017 07:07:16 GMT https://community.qlik.com/t5/QlikView/month-wise-VALUE/m-p/1256767#M851317 ganeshsvm 2017-03-09T07:07:16Z