Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

Thanks for your help!

Maarten

1 Solution

Accepted Solutions
Not applicable
Author

Maarten,

so far I see it´s what you want.

Or I´m missing something?

Rainer

View solution in original post

7 Replies
Not applicable
Author

Hi Maarten,

for a first idea please see the modified example.

Hope it helps.

Good luck!

Rainer

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI

    

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

       Hope it will help you

Thanks

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

HI

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

Thanks

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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.

QV_Schema_1.png

QV_Schema_2.png

Kind regards,

Thanks in advance,

Maarten

Not applicable
Author

Maarten,

so far I see it´s what you want.

Or I´m missing something?

Rainer

Not applicable
Author

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