topic Re: Statistics on statistics in QlikView

Statistics on statistics

Wed, 18 May 2011 06:08:17 GMT

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

Re: Statistics on statistics

Wed, 18 May 2011 08:41:32 GMT

Hi Maarten,

for a first idea please see the modified example.

Hope it helps.

Good luck!

Rainer

Re: Statistics on statistics

kaushiknsolanki — Wed, 18 May 2011 08:50:13 GMT

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

Hope it will help you

Thanks

Statistics on statistics

Wed, 18 May 2011 08:56:32 GMT

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

kaushiknsolanki — Wed, 18 May 2011 08:59:33 GMT

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

Thanks

Re: Statistics on statistics

Wed, 18 May 2011 09:16:56 GMT

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

Re: Statistics on statistics

Wed, 18 May 2011 10:45:52 GMT

Maarten,

so far I see it´s what you want.

Or I´m missing something?

Rainer

Re: Statistics on statistics

Wed, 18 May 2011 12:15:00 GMT

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