Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
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

HI

    

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

       Hope it will help you

Thanks

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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

HI

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

Thanks

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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