topic Re: firstsortvalue not allowing static chart in QlikView https://community.qlik.com/t5/QlikView/firstsortvalue-not-allowing-static-chart/m-p/747480#M266742 <HTML><HEAD></HEAD><BODY><P>Add them in a set modifier for the firstsortedvalue function too.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum( {&lt;MONTH=,MonthNew=,WEEK=,WeekNew=&gt;} Aggr(FirstSortedValue (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">{&lt;MONTH=,MonthNew=,WEEK=,WeekNew=&gt;}</SPAN>COMPLETED_AMOUNT,-Id),uniquetradeid,ORDER_ID))</SPAN></P></BODY></HTML> Fri, 14 Nov 2014 10:38:34 GMT Gysbert_Wassenaar 2014-11-14T10:38:34Z firstsortvalue not allowing static chart https://community.qlik.com/t5/QlikView/firstsortvalue-not-allowing-static-chart/m-p/747479#M266741 <HTML><HEAD></HEAD><BODY><P>Hi, I have this expression in a chart:</P><P>sum( {&lt;MONTH=,MonthNew=,WEEK=,WeekNew=} Aggr(FirstSortedValue (COMPLETED_AMOUNT,-Id),uniquetradeid,ORDER_ID))</P><P></P><P>I've tried to put in all the date fields as above to prevent date selections from changing the chart, but it's not working. This is only occurring with firstsortvalue. Thanks.</P></BODY></HTML> Fri, 14 Nov 2014 10:32:55 GMT https://community.qlik.com/t5/QlikView/firstsortvalue-not-allowing-static-chart/m-p/747479#M266741 sifatnabil 2014-11-14T10:32:55Z Re: firstsortvalue not allowing static chart https://community.qlik.com/t5/QlikView/firstsortvalue-not-allowing-static-chart/m-p/747480#M266742 <HTML><HEAD></HEAD><BODY><P>Add them in a set modifier for the firstsortedvalue function too.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum( {&lt;MONTH=,MonthNew=,WEEK=,WeekNew=&gt;} Aggr(FirstSortedValue (<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">{&lt;MONTH=,MonthNew=,WEEK=,WeekNew=&gt;}</SPAN>COMPLETED_AMOUNT,-Id),uniquetradeid,ORDER_ID))</SPAN></P></BODY></HTML> Fri, 14 Nov 2014 10:38:34 GMT https://community.qlik.com/t5/QlikView/firstsortvalue-not-allowing-static-chart/m-p/747480#M266742 Gysbert_Wassenaar 2014-11-14T10:38:34Z