received workload Calculations

[#1]

Hi Guys

I am New to Qlikview , i have a requirement from the Client for a call center .

i want to count IDs which occured Previous day (Today()-1): 6am to 6pm and Today() before 6am

Pieces I need to make up an Expression .

EMAIL=

Count (ID)

Where TASK = “TS00207914” And

[Creation date] = Today – 1 or [Creation date] = Today() & [Creation Time] <6:00:00 AM]

Can Anyone Interpret this in an Expression that ca make sense .

[sunny_talwar]

The attached application only contain data for 01/03/2016 date. Today is 15/03/2016, not sure if you want it based on today or max date?