Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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?