Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

Table aggregation help (i think)

Hi all,

first of all thanks for any help with this guys,

as you can see in the table below Equipment M01_0001_3GR_1 fails 7 times with a comms error.

each error has a raised time and a clearance time.

I want to count the faults that occur within 3 days of one another.

in my table I want to have Fault Classification as a dimension and the above calculation as the expression.

0 Replies