topic Set analysis not working correctly? in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-not-working-correctly/m-p/323294#M119122 <HTML><HEAD></HEAD><BODY><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Co Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Batch ID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>File #</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Reg Hours</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>O/T Hours</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 1 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 1 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 2 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 2 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 1 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 1 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 2 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 2 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Temp Rate</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Temp Dept</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Shift</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Pay #</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Tax Frequency</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Gross Receipts</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">40.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">24.63</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.00</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">37.91</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PTO</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">16.00</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>Expressions:</P><P></P><P>Reg Hours:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P> sum(aggr(if(sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])&gt;=40,40,sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])),[Employee ID],[Paycor Week Ending]))</P></PRE><P></P><P>O/T Hours:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>sum(aggr(if(sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])&gt;=40,sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])-40,0),[Employee ID],[Paycor Week Ending]))</P></PRE><P></P><P>Hours 1 Amount:</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>sum({&lt;[Hours Code]-={''},[Paycor Time Off]={'1'}&gt;}[Paycor Hours])</P></PRE><P></P><P>With the above information, how is <SPAN style="color: #363636;">37.91 showing up on the second line? Line 1 should show 77.91 but I do not know why it is not.</SPAN></P><P></P><P><SPAN style="color: #363636;">Edit:</SPAN></P><P></P><P><SPAN style="color: #363636;">Here is a table box with the values used above.</SPAN></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>File #</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Week Ending</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Hours</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Time Off</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/13/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8.00</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/13/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9.50</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/14/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11.18</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/15/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.15</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/16/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.33</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/17/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.27</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/18/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5.20</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/20/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PTO</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/21/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PTO</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/22/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9.93</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/23/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11.15</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/24/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.80</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/25/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6.03</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 27 Feb 2012 18:50:20 GMT 2012-02-27T18:50:20Z Set analysis not working correctly? https://community.qlik.com/t5/QlikView/Set-analysis-not-working-correctly/m-p/323294#M119122 <HTML><HEAD></HEAD><BODY><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Co Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Batch ID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>File #</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Reg Hours</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>O/T Hours</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 1 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 1 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 2 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours 2 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 1 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 1 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 2 Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Earnings 2 Amount</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Temp Rate</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Temp Dept</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Shift</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Pay #</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Tax Frequency</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Gross Receipts</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">40.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">24.63</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.00</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">37.91</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PTO</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">16.00</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><BR /></TD></TR></TBODY></TABLE><P></P><P></P><P>Expressions:</P><P></P><P>Reg Hours:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P> sum(aggr(if(sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])&gt;=40,40,sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])),[Employee ID],[Paycor Week Ending]))</P></PRE><P></P><P>O/T Hours:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>sum(aggr(if(sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])&gt;=40,sum({&lt;[Hours Code]={''},[Paycor Time Off]={'0'}&gt;}[Paycor Hours])-40,0),[Employee ID],[Paycor Week Ending]))</P></PRE><P></P><P>Hours 1 Amount:</P><P></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>sum({&lt;[Hours Code]-={''},[Paycor Time Off]={'1'}&gt;}[Paycor Hours])</P></PRE><P></P><P>With the above information, how is <SPAN style="color: #363636;">37.91 showing up on the second line? Line 1 should show 77.91 but I do not know why it is not.</SPAN></P><P></P><P><SPAN style="color: #363636;">Edit:</SPAN></P><P></P><P><SPAN style="color: #363636;">Here is a table box with the values used above.</SPAN></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>File #</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Week Ending</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Hours</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Hours Code</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Paycor Time Off</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/13/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8.00</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/13/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9.50</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/14/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11.18</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/15/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.15</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/16/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.33</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/17/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.27</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/18/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/19/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5.20</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/20/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PTO</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/21/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">8.00</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">PTO</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/22/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">9.93</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/23/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11.15</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/24/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10.80</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">202</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/25/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2/26/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6.03</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 27 Feb 2012 18:50:20 GMT https://community.qlik.com/t5/QlikView/Set-analysis-not-working-correctly/m-p/323294#M119122 2012-02-27T18:50:20Z Set analysis not working correctly? https://community.qlik.com/t5/QlikView/Set-analysis-not-working-correctly/m-p/323295#M119123 <HTML><HEAD></HEAD><BODY><P>I found the solution. Adding Hours Code to the aggr seems to fix it.</P></BODY></HTML> Mon, 27 Feb 2012 19:16:35 GMT https://community.qlik.com/t5/QlikView/Set-analysis-not-working-correctly/m-p/323295#M119123 2012-02-27T19:16:35Z