topic Table aggregation help (i think) in QlikView https://community.qlik.com/t5/QlikView/Table-aggregation-help-i-think/m-p/922540#M988684 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>first of all thanks for any help with this guys,</P><P>as you can see in the table below Equipment M01_0001_3GR_1 fails 7 times with a comms error.</P><P>each error has a raised time and a clearance time.</P><P>I want to count the faults that occur within 3 days of one another.</P><P></P><P>in my table I want to have Fault Classification as a dimension and the above calculation as the expression.</P><P></P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94583_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 30 Jul 2015 15:31:02 GMT samuel_brierley 2015-07-30T15:31:02Z Table aggregation help (i think) https://community.qlik.com/t5/QlikView/Table-aggregation-help-i-think/m-p/922540#M988684 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>first of all thanks for any help with this guys,</P><P>as you can see in the table below Equipment M01_0001_3GR_1 fails 7 times with a comms error.</P><P>each error has a raised time and a clearance time.</P><P>I want to count the faults that occur within 3 days of one another.</P><P></P><P>in my table I want to have Fault Classification as a dimension and the above calculation as the expression.</P><P></P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94583_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 30 Jul 2015 15:31:02 GMT https://community.qlik.com/t5/QlikView/Table-aggregation-help-i-think/m-p/922540#M988684 samuel_brierley 2015-07-30T15:31:02Z