topic Re: Set analysis condition with count in QlikView

Set analysis condition with count

vesiletaskiran — Mon, 21 Jan 2019 17:10:58 GMT

I have 2 qvds. Ticket and Order. TICKET_ID is common in both vds.

Ticket.qvd - > TICKET_ID, TICKET_STATUS

Task.qvd-> TICKET_ID, ORDERID, ArriveTime(min),

I need to calculate Tickets with more than 1 task having more than 30 mins TravelTime.

I dont want to join 2 models because of performance issues.

Is it possible to make this with set analysis ? Something like below

count({$<TICKET_STATUS={"closed"}, Aggr(Count(TravelTime = {">30"},ORDERID)={">1"}>} TICKET_ID)

Thanks in advance.

Gysbert_Wassenaar — Mon, 21 Jan 2019 18:02:22 GMT

Perhaps like this: count({<TICKET_ID={"=count({<TravelTime={">30"}>}ORDERID)>1"}>}TICKET_ID)

vesiletaskiran — Mon, 21 Jan 2019 18:43:05 GMT

Thanks a lottt. This works perfect