topic Re: real-time count by group in QlikView

real-time count by group

Mon, 22 Oct 2012 13:28:34 GMT

Hi !

I found some problem with this simple task.

I have table with 2 dimensions:

1. gruppa

2. otveststv

and then i try to do:

1. Add expression count(tasks)

2. Add condition: if(count(tasks) >= 2,1,0)

3. Now i want to count: how many otveststv in each gruppa is good by condition

Please see attached files.

How can i get something like this?

Please help if you can

Re: real-time count by group

spividori — Mon, 22 Oct 2012 14:31:20 GMT

Hi!

See the attached example.
Hope this helps.

Regards.

Re: real-time count by group

Tue, 23 Oct 2012 07:27:12 GMT

Thank you, Sandro!

This is helpful, with agrr function i could find whou many tasks good by condition.

Now i have this table ( third table in image):

but in result chart i need table with:

gruppa, count types (good by condition), count tasks (good by condition), Avarage by condition = count tasks (good by condition) / count tasks (good by condition)

in excel its look very simple:

but in QV i can't get this final table.

Re: real-time count by group

Wed, 24 Oct 2012 08:30:14 GMT

i found it.

Re: real-time count by group

spividori — Wed, 24 Oct 2012 09:21:08 GMT

Congratulations! I'm testing and do not know it.

Regards.