https://community.qlik.com/t5/QlikView/Set-values-in-the-dynamic-table/m-p/1532097#M509270 <P>Would you be able to share your app to test this out?</P> Fri, 18 Jan 2019 13:06:45 GMT sunny_talwar 2019-01-18T13:06:45Z https://community.qlik.com/t5/QlikView/Set-values-in-the-dynamic-table/m-p/1531836#M509269 <P><SPAN>Dear experts, A favor I need your support for the next case. With the following script I show the USD data of the last day for each month. SUM (aggr (if (Period = MAX (total &lt;Period2&gt; Period), USD), GROUP, NOMOFC, Code, RUC2, Name, Type, Period2, Day, IDRegistro)) What I need is that when I use the filters of year, month, day, etc. the value of 201812 stays fixed without needing to move but when I filter the days of 2019 filter the values.</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="grafico.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/3997i18226B4C09EB2768/image-size/large?v=v2&amp;px=999" role="button" title="grafico.jpg" alt="grafico.jpg" /></span></P> Fri, 18 Jan 2019 00:14:03 GMT https://community.qlik.com/t5/QlikView/Set-values-in-the-dynamic-table/m-p/1531836#M509269 fabio182 2019-01-18T00:14:03Z https://community.qlik.com/t5/QlikView/Set-values-in-the-dynamic-table/m-p/1532097#M509270 <P>Would you be able to share your app to test this out?</P> Fri, 18 Jan 2019 13:06:45 GMT https://community.qlik.com/t5/QlikView/Set-values-in-the-dynamic-table/m-p/1532097#M509270 sunny_talwar 2019-01-18T13:06:45Z