topic Table not refreshing data in App Development https://community.qlik.com/t5/App-Development/Table-not-refreshing-data/m-p/31194#M2111 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have 3 tables on a worksheet.</P><P>The first table is for Week - This is dependent on user selection of week.</P><P>The 2nd and 3rd table are showing details of Month to Date and Year to Date (Date of Week selected)</P><P></P><P>I am using the formula as below for month - for year I use inyeartodate</P><P>sum({1}-1*(InmonthToDate(SCSDAT,CurYearWeekEnd,0)*SCPAX))</P><P>SCSDAT - is the date field</P><P>CurYearWeekEnd is the selected value from the filter - this is a field in the table and is equivalent to weekend(SCSDAT)</P><P>SCPAX is the field I want sum of.</P><P></P><P>The weekly table gets refreshed on change of the week selection</P><P></P><P>However the 2 other tables which are for month and year don't refresh with the new selection. However if I open and edit the table and change the formula (rather re-save) then the table gets refreshed and correct values are displayed</P><P></P><P>Anyway for refreshing the other 2 tables automatically? Is there a refresh command?</P><P></P><P>Any work around would be appreciated.</P><P>Thanks</P><P>Arvind</P></BODY></HTML> Thu, 15 Mar 2018 08:47:03 GMT avermalla 2018-03-15T08:47:03Z Table not refreshing data https://community.qlik.com/t5/App-Development/Table-not-refreshing-data/m-p/31194#M2111 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have 3 tables on a worksheet.</P><P>The first table is for Week - This is dependent on user selection of week.</P><P>The 2nd and 3rd table are showing details of Month to Date and Year to Date (Date of Week selected)</P><P></P><P>I am using the formula as below for month - for year I use inyeartodate</P><P>sum({1}-1*(InmonthToDate(SCSDAT,CurYearWeekEnd,0)*SCPAX))</P><P>SCSDAT - is the date field</P><P>CurYearWeekEnd is the selected value from the filter - this is a field in the table and is equivalent to weekend(SCSDAT)</P><P>SCPAX is the field I want sum of.</P><P></P><P>The weekly table gets refreshed on change of the week selection</P><P></P><P>However the 2 other tables which are for month and year don't refresh with the new selection. However if I open and edit the table and change the formula (rather re-save) then the table gets refreshed and correct values are displayed</P><P></P><P>Anyway for refreshing the other 2 tables automatically? Is there a refresh command?</P><P></P><P>Any work around would be appreciated.</P><P>Thanks</P><P>Arvind</P></BODY></HTML> Thu, 15 Mar 2018 08:47:03 GMT https://community.qlik.com/t5/App-Development/Table-not-refreshing-data/m-p/31194#M2111 avermalla 2018-03-15T08:47:03Z