Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysis problem

Hi,  I'm struggling with a bit of set analysis. From the sample data below I'm trying to do a count of calls into response groups where they are missed. So id 1 went to 3 different users but was answered by one person so my expression would return 0. Id 2 went to 4 different users and was not answered by anyone and therefore would return 1.

ID      call_response

1       Answered

1       Missed

1       Missed

2       Missed

2       Missed

2       Missed

2       Missed

Help please!

Thanks

Neil

Tags (2)
1 Reply

Re: Set analysis problem

Hi,

     Try this,

          =If(Aggr(Count({<call_response = {'Answered'}>}call_response),ID) > 0 ,0 ,1)

     Hope it helps

Community Browser