Statistics on statistics

[#1]

Hi guys,

I have one qlikview inline table on which i do statistics: I count the number of occurances of a certain 'property' per encounter.

As a next step I want to aggregate on that calculated number of occurances, and count the number of 'properties'.

As I'm having difficulties to explain in words what I would like to have, I posted an example which (hopefully) makes things clear ...

I suppose it is quite easy to do, but I can't get it done 🙂

Therefore a simplified example of what I try to achieve.

Thanks for your help!

Maarten

[#2]

Hi Maarten,

for a first idea please see the modified example.

Hope it helps.

Good luck!

Rainer

[kaushiknsolanki]

HI

       I am here by  sending you the application which have count of the encounter by Person.

       Hope it will help you

Thanks

[#4]

Hi,

Thanks for your proposal, but I'm affraid it does not push me in the right direction. Rainer on the other hand is getting a bit closer to what I need.

10Q anyway!

Regards,

Maarten

[kaushiknsolanki]

HI

        Can you please try to discribe your problem in detail. Try explaining with some example.

Thanks

[#6]

Hello Rainer,

It seems that you are on the right track, but I think the problems lies in the fact that we need to aggregate on the results of the count of occurances per propertie.

I enclosed two images which should explain more what the purpose is.

Kind regards,

Thanks in advance,

Maarten

[#7 · Accepted solution]

Maarten,

so far I see it´s what you want.

Or I´m missing something?

Rainer

[#8]

Hi Rainer,

You are absolutely right. I made an error when taking a look at your example.

The first example deed indeed already tackle the problem.

Thanks a lot for your fast and accurate response!

Kind regards,

Maarten