Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vesiletaskiran
New Contributor III

Set analysis condition with count

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. 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set analysis condition with count

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

talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Set analysis condition with count

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

talk is cheap, supply exceeds demand
vesiletaskiran
New Contributor III

Re: Set analysis condition with count

Thanks a lottt. This works perfect