topic Re: how to write the expression in QlikView https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417012#M459510 <HTML><HEAD></HEAD><BODY><P><STRONG>Try</STRONG></P><P></P><P><STRONG>Sum({&lt;CALMONTH = {"&gt;=$(=date(YearStart(Max(CALMONTH)),'YYYYMM')) &lt;$(=date(max(CALMONTH),'YYYYMM'))"}&gt;} </STRONG></P></BODY></HTML> Thu, 14 Sep 2017 11:22:18 GMT shraddha_g 2017-09-14T11:22:18Z how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417010#M459508 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>can any one help me in achieving this requirement.....the thing is i need to show sum of volume against recommended R_Calmonth column&nbsp; what i mean is </P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176550_Capture.PNG" style="height: 282px; width: 620px;" /></P><P></P><P>what i need to show for&nbsp;&nbsp; R_Calmonth&nbsp; <SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp; 201707 =201704+201705+201706 which is&nbsp; 1600+1600+1768&nbsp; =4968</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201708=<SPAN style="font-size: 13.3333px;">201704+201705+201706 +201707 which is <SPAN style="font-size: 13.3333px;">&nbsp; 1600+1600+1768+400=5368</SPAN></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201709=<SPAN style="font-size: 13.3333px;">201704+201705+201706 +201707+201708 <SPAN style="font-size: 13.3333px;">which is </SPAN><SPAN style="font-size: 13.3333px;">&nbsp; 1600+1600+1768+400=5368(beacuse i dont have any volume for 201708)</SPAN></SPAN></P><P></P><P></P><P>Expression i tried is</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp;&nbsp; Actual:&nbsp; </SPAN><STRONG> Sum({&lt;CALMONTH = {"&gt;=$(=YearStart(Max(CALMONTH))) &lt;$(=max(CALMONTH))"}&gt;} VOLUME)</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>but i am not getting expected output</P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/176558_Capture1.PNG" style="height: 299px; width: 620px;" /></P><P></P><P>Any suggestion plz </P><P></P><P>thanks</P><P>Naveen</P></BODY></HTML> Thu, 14 Sep 2017 11:18:23 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417010#M459508 kunkumnaveen 2017-09-14T11:18:23Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417011#M459509 <HTML><HEAD></HEAD><BODY><P>can you share sample app?</P></BODY></HTML> Thu, 14 Sep 2017 11:21:11 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417011#M459509 shraddha_g 2017-09-14T11:21:11Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417012#M459510 <HTML><HEAD></HEAD><BODY><P><STRONG>Try</STRONG></P><P></P><P><STRONG>Sum({&lt;CALMONTH = {"&gt;=$(=date(YearStart(Max(CALMONTH)),'YYYYMM')) &lt;$(=date(max(CALMONTH),'YYYYMM'))"}&gt;} </STRONG></P></BODY></HTML> Thu, 14 Sep 2017 11:22:18 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417012#M459510 shraddha_g 2017-09-14T11:22:18Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417013#M459511 <HTML><HEAD></HEAD><BODY><P>i wish but i am having client data with me,i will loose my job</P></BODY></HTML> Thu, 14 Sep 2017 11:23:28 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417013#M459511 kunkumnaveen 2017-09-14T11:23:28Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417014#M459512 <HTML><HEAD></HEAD><BODY><P>You can create a Sample app to test with Dummy data with same scenario.</P><P></P><P>It will be easy to help you better to understand you data and&nbsp; data model </P></BODY></HTML> Thu, 14 Sep 2017 11:25:20 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417014#M459512 shraddha_g 2017-09-14T11:25:20Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417015#M459513 <HTML><HEAD></HEAD><BODY><P>I tired your expression but it is not working it is coming as nulls </P></BODY></HTML> Thu, 14 Sep 2017 11:25:34 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417015#M459513 kunkumnaveen 2017-09-14T11:25:34Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417016#M459514 <HTML><HEAD></HEAD><BODY><P>How R_CalMonth and CALMONTH are related?</P></BODY></HTML> Thu, 14 Sep 2017 11:26:40 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417016#M459514 shraddha_g 2017-09-14T11:26:40Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417017#M459515 <HTML><HEAD></HEAD><BODY><P>based up on</P><P><STRONG>part,supplier,plant,fiscalyear combination</STRONG></P></BODY></HTML> Thu, 14 Sep 2017 11:28:51 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417017#M459515 kunkumnaveen 2017-09-14T11:28:51Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417018#M459516 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176560_Capture2.PNG" style="height: auto;" /></P><P></P><P>Based up Key6</P></BODY></HTML> Thu, 14 Sep 2017 11:32:15 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417018#M459516 kunkumnaveen 2017-09-14T11:32:15Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417019#M459517 <HTML><HEAD></HEAD><BODY><P>Any Suggestion on how to write the expression please</P></BODY></HTML> Thu, 14 Sep 2017 11:37:56 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417019#M459517 kunkumnaveen 2017-09-14T11:37:56Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417020#M459518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this :</P><P></P><P><STRONG>=aggr( rangesum(above( sum(CALMONTH), 1, rowno() )), VOLUME)&nbsp; </STRONG></P></BODY></HTML> Thu, 14 Sep 2017 11:39:11 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417020#M459518 Anonymous 2017-09-14T11:39:11Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417021#M459519 <HTML><HEAD></HEAD><BODY><P>HI,</P><P><SPAN style="font-size: 13.3333px;">It is giving only aggr value....</SPAN></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176562_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 14 Sep 2017 11:43:49 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417021#M459519 kunkumnaveen 2017-09-14T11:43:49Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417022#M459520 <HTML><HEAD></HEAD><BODY><P>Is this&nbsp; requirement is not possible to achieve ? </P></BODY></HTML> Thu, 14 Sep 2017 12:38:51 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417022#M459520 kunkumnaveen 2017-09-14T12:38:51Z Re: how to write the expression https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417023#M459521 <HTML><HEAD></HEAD><BODY><P>It is possible to achieve but scenario is not clear.</P><P></P><P>May be one of the experts can help you.</P></BODY></HTML> Thu, 14 Sep 2017 14:25:53 GMT https://community.qlik.com/t5/QlikView/how-to-write-the-expression/m-p/1417023#M459521 shraddha_g 2017-09-14T14:25:53Z