topic Set analysis - subtraction in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-subtraction/m-p/416910#M154994 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P>I have an expression that gives me number of not executed processes in a selected time period. I can get the count accurate. However, am not able to get to the actual "process_id" that are not executed.</P><P></P><P>=count({&lt;start_time=&gt;}process_id) - count(DISTINCT If(Aggr(NODISTINCT Max({$&lt;reviewed_status= &gt;}start_time), process_id) = start_time, process_id)) </P><P></P><P>For example, in my process table I have 5 proceses, and only 4 of them have a row in process_execution table for a given start time, I need to get to the 5th process_id that has now row in the process_execution table.</P><P>Thanks in advance for any help,</P><P>Shilpa</P></BODY></HTML> Mon, 15 Oct 2012 22:05:09 GMT 2012-10-15T22:05:09Z Set analysis - subtraction https://community.qlik.com/t5/QlikView/Set-analysis-subtraction/m-p/416910#M154994 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P>I have an expression that gives me number of not executed processes in a selected time period. I can get the count accurate. However, am not able to get to the actual "process_id" that are not executed.</P><P></P><P>=count({&lt;start_time=&gt;}process_id) - count(DISTINCT If(Aggr(NODISTINCT Max({$&lt;reviewed_status= &gt;}start_time), process_id) = start_time, process_id)) </P><P></P><P>For example, in my process table I have 5 proceses, and only 4 of them have a row in process_execution table for a given start time, I need to get to the 5th process_id that has now row in the process_execution table.</P><P>Thanks in advance for any help,</P><P>Shilpa</P></BODY></HTML> Mon, 15 Oct 2012 22:05:09 GMT https://community.qlik.com/t5/QlikView/Set-analysis-subtraction/m-p/416910#M154994 2012-10-15T22:05:09Z