topic Re: HOW THE OUTPUT WILL DIFFER in QlikView https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187223#M885391 <HTML><HEAD></HEAD><BODY><P>Nothing there, If you use first expression the performance is ok but file size is bit increased. This scenario, I would recommend to use second one</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>sum({&lt;Month={'=$(=month(max(Date)))'},Year={'=$(=year(max(Date)))'}&gt;}[Sales Amount])</STRONG></SPAN></P></BODY></HTML> Mon, 19 Sep 2016 07:14:01 GMT Anil_Babu_Samineni 2016-09-19T07:14:01Z HOW THE OUTPUT WILL DIFFER https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187220#M885388 <HTML><HEAD></HEAD><BODY><P>HI</P><P>Please go through both the set and tell me the difference in output??</P><P>1-=sum({&lt;Month={$(=month(max({&lt;Year={$(=year(max(Date)))}&gt;}Date)))},Year={$(=year(max(Date)))}&gt;}[Sales Amount])</P><P></P><P>2-=sum({&lt;Month={$(=month(max(Date)))},Year={$(=year(max(Date)))}&gt;}[Sales Amount])</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187220#M885388 lionking15 2020-11-25T16:16:04Z Re: HOW THE OUTPUT WILL DIFFER https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187221#M885389 <HTML><HEAD></HEAD><BODY><P>I don't think you will see any difference...</P></BODY></HTML> Mon, 19 Sep 2016 05:59:06 GMT https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187221#M885389 trdandamudi 2016-09-19T05:59:06Z Re: HOW THE OUTPUT WILL DIFFER https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187222#M885390 <HTML><HEAD></HEAD><BODY><P>The output won't differ. </P></BODY></HTML> Mon, 19 Sep 2016 05:59:35 GMT https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187222#M885390 Gysbert_Wassenaar 2016-09-19T05:59:35Z Re: HOW THE OUTPUT WILL DIFFER https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187223#M885391 <HTML><HEAD></HEAD><BODY><P>Nothing there, If you use first expression the performance is ok but file size is bit increased. This scenario, I would recommend to use second one</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>sum({&lt;Month={'=$(=month(max(Date)))'},Year={'=$(=year(max(Date)))'}&gt;}[Sales Amount])</STRONG></SPAN></P></BODY></HTML> Mon, 19 Sep 2016 07:14:01 GMT https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187223#M885391 Anil_Babu_Samineni 2016-09-19T07:14:01Z Re: HOW THE OUTPUT WILL DIFFER https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187224#M885393 <HTML><HEAD></HEAD><BODY><P>Nope there will be mo change in the output but the equation 1 is more detailed but not required. Equation2 is more than enough.</P></BODY></HTML> Mon, 19 Sep 2016 09:35:29 GMT https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187224#M885393 2016-09-19T09:35:29Z Re: HOW THE OUTPUT WILL DIFFER https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187225#M885395 <HTML><HEAD></HEAD><BODY><P>No change in the output. </P></BODY></HTML> Mon, 19 Sep 2016 15:38:12 GMT https://community.qlik.com/t5/QlikView/HOW-THE-OUTPUT-WILL-DIFFER/m-p/1187225#M885395 shree909 2016-09-19T15:38:12Z