topic Qlikview - text object num in QlikView https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155171#M1252448 <HTML><HEAD></HEAD><BODY><P>I have text object with text </P><P></P><P></P><P>&nbsp;&nbsp;&nbsp; =num( Sum( Aggr( Quantity*Price, PostingYear1, sPosting Date] )), '#,##0.0')</P><P></P><P></P><P>and I have year 2015 and 2016.</P><P>When save this expresions i got sum of bouth year 2015 and 2016. how to get only 2015?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z Qlikview - text object num https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155171#M1252448 <HTML><HEAD></HEAD><BODY><P>I have text object with text </P><P></P><P></P><P>&nbsp;&nbsp;&nbsp; =num( Sum( Aggr( Quantity*Price, PostingYear1, sPosting Date] )), '#,##0.0')</P><P></P><P></P><P>and I have year 2015 and 2016.</P><P>When save this expresions i got sum of bouth year 2015 and 2016. how to get only 2015?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155171#M1252448 2026-01-26T18:19:17Z Re: Qlikview - text object num https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155172#M1252451 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Num(Sum(<SPAN style="color: #ff0000;">{&lt;Year = {2015}&gt;}</SPAN> Aggr(<SPAN style="color: #ff0000;">Only(</SPAN><SPAN style="color: #ff0000;">{&lt;Year = {2015}&gt;}</SPAN> Quantity*Price<SPAN style="color: #ff0000;">)</SPAN>, PostingYear1, sPosting Date])), '#,##0.0')</STRONG></SPAN></P></BODY></HTML> Tue, 09 Aug 2016 11:39:17 GMT https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155172#M1252451 sunny_talwar 2016-08-09T11:39:17Z Re: Qlikview - text object num https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155173#M1252452 <HTML><HEAD></HEAD><BODY><P>instead 5000 i got 4973, what can be problem</P></BODY></HTML> Tue, 09 Aug 2016 12:03:37 GMT https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155173#M1252452 2016-08-09T12:03:37Z Re: Qlikview - text object num https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155174#M1252454 <HTML><HEAD></HEAD><BODY><P>Very difficult to say by just looking at the numbers. Would you be able to share a sample?</P></BODY></HTML> Tue, 09 Aug 2016 15:51:21 GMT https://community.qlik.com/t5/QlikView/Qlikview-text-object-num/m-p/1155174#M1252454 sunny_talwar 2016-08-09T15:51:21Z