topic Re: received workload Calculations in QlikView https://community.qlik.com/t5/QlikView/received-workload-Calculations/m-p/1076740#M931703 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 15 Mar 2016 14:12:50 GMT sunny_talwar 2016-03-15T14:12:50Z received workload Calculations https://community.qlik.com/t5/QlikView/received-workload-Calculations/m-p/1076739#M931702 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I am New to Qlikview , i have a requirement from the Client for a call center . </P><P><SPAN style="color: #1f497d; font-size: 10pt; font-family: Calibri, sans-serif;">i want to count IDs which occured</SPAN><SPAN style="color: #1f497d; font-size: 10pt; font-family: Calibri, sans-serif;"> Previous day (Today()-1): 6am to 6pm </SPAN><SPAN style="color: #002060; font-size: 10pt; font-family: Calibri, sans-serif;"><STRONG><EM>and</EM></STRONG></SPAN><SPAN style="color: #002060; font-size: 10pt; font-family: Calibri, sans-serif;"><STRONG> </STRONG></SPAN><SPAN style="color: #1f497d; font-size: 10pt; font-family: Calibri, sans-serif;">Today() before 6am</SPAN></P><P></P><P>Pieces I need to make up an Expression .</P><P></P><P>EMAIL= </P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count </SPAN> (ID)</P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Where</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">TASK</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> = “TS00207914” </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">And</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> </SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">[</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Creation date]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> = </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New';">Today <SPAN style="color: black;">– 1 or </SPAN><SPAN style="color: maroon;"> [Creation date]</SPAN><SPAN style="color: black;"> = Today() &amp; </SPAN><SPAN style="color: maroon;">[Creation Time]</SPAN><SPAN style="color: black;"> &lt;6:00:00 AM]</SPAN></SPAN></P><P><SPAN style="color: black; font-size: 9.0pt; font-family: 'Courier New';"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Courier New';"><SPAN style="font-size: 9pt;">Can Anyone </SPAN><SPAN style="font-size: 12px;">Interpret this in an Expression that ca make sense </SPAN><SPAN style="font-size: 9pt;"> . </SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/received-workload-Calculations/m-p/1076739#M931702 2020-11-25T16:16:04Z Re: received workload Calculations https://community.qlik.com/t5/QlikView/received-workload-Calculations/m-p/1076740#M931703 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Tue, 15 Mar 2016 14:12:50 GMT https://community.qlik.com/t5/QlikView/received-workload-Calculations/m-p/1076740#M931703 sunny_talwar 2016-03-15T14:12:50Z