topic Top 5 from yesterday... in QlikView https://community.qlik.com/t5/QlikView/Top-5-from-yesterday/m-p/1375340#M799154 <HTML><HEAD></HEAD><BODY><P>Maybe I am just overthinking this, but this used to work, now it suddenly quit working and I'm not sure why. This would show the top 5 clients that we distributed the previous day. (Just a heads up, the previous day data is actually attached to today's date in Date_RD)</P><P></P><P>Dimension:</P><P>Program</P><P></P><P>Measurment:</P><P>Sum({$&lt;Date_RD={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Area={'Distribution Orders'}&gt;} Processed)</P><P></P><P>attached is the app...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT joshrussin 2020-11-25T16:16:04Z Top 5 from yesterday... https://community.qlik.com/t5/QlikView/Top-5-from-yesterday/m-p/1375340#M799154 <HTML><HEAD></HEAD><BODY><P>Maybe I am just overthinking this, but this used to work, now it suddenly quit working and I'm not sure why. This would show the top 5 clients that we distributed the previous day. (Just a heads up, the previous day data is actually attached to today's date in Date_RD)</P><P></P><P>Dimension:</P><P>Program</P><P></P><P>Measurment:</P><P>Sum({$&lt;Date_RD={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Area={'Distribution Orders'}&gt;} Processed)</P><P></P><P>attached is the app...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-5-from-yesterday/m-p/1375340#M799154 joshrussin 2020-11-25T16:16:04Z