7 Replies Latest reply: May 18, 2011 8:26 AM by Maarten Van Damme

# Statistics on statistics

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.

Maarten

• ###### Re: Statistics on statistics

Hi Maarten,

for a first idea please see the modified example.

Hope it helps.

Good luck!

Rainer

• ###### Re: Statistics on statistics

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,

Maarten

• ###### Re: Statistics on statistics

Maarten,

so far I see it´s what you want.

Or I´m missing something?

Rainer

• ###### Re: Statistics on statistics

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

• ###### Re: Statistics on statistics

HI

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

Thanks

• ###### Statistics on statistics

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

• ###### Statistics on statistics

HI

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

Thanks