Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-03-15 08:35 AM

received workload Calculations

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 .

Time formatting.qvw
200 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2016-03-15 10:12 AM

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?

137 Views
0 Likes