Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Top 5 from yesterday...

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)

Dimension:

Program

Measurment:

Sum({$<Date_RD={"$(=FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))"}, Area={'Distribution Orders'}>} Processed)

attached is the app...

0 Replies