Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis issue

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

Labels (1)
2 Replies
Not applicable
Author

Could you include some sample data?

Not applicable
Author

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.