topic set analysis issue in QlikView

set analysis issue

Thu, 14 Aug 2014 13:28:26 GMT

Hi guys!

I want to calculate the percentage of inhabitants that have called for information.

But for example 5000 calls have been recieven and I only have 1000 inhabitants.

So 1 inhabitant called approximatly 5 times.

But I don't want to see that.

When an inhabitant has called I dont want to count his other calls.

So when the inhabitant_id has already an inforequest, I don't want to count the others.

This is what I have for now:

count(DISTINCT {<inforequest_origin_id={'30'}>} inforequest_id)

NullCount(total{< inforequest_source_id=>} inhabitant_until)

Can you help me?

Kind regards,

Katleen

Re: set analysis issue

Thu, 14 Aug 2014 13:43:31 GMT

Could you include some sample data?

Re: set analysis issue

Thu, 14 Aug 2014 14:23:31 GMT

It seems like just a Count(Distinct inforequest_id) will do in your case. Not sure why set analysis would be required here. Can you attach a sample app with the results you are expecting.