topic Re: How do i get this count in a table in QlikView

How do i get this count in a table

D19PAL — Mon, 26 Sep 2022 10:30:58 GMT

Hi,

How do i get this count in a table

Data

Name, Manager,ID,Class,Position

John,james,1,art,student

Dan,james,2,art,student

James,simon,3,art,teacher

Tony,peter,4,art,student

I need to count by position, how many Name and Manager have the same Class,

So group 1 is Class Art John and Dan share a class with their Manager, so I want to show John, Dan and the Manager James.

Table

Class,Position,Total

art,student,2

art,teacher,1

Table 2

ID,Name,Class,Count

1, john,art,1

2, Dan,art,1

3,James,art,1

Thanks much appreciated

Re: How do i get this count in a table

Ryan69 — Thu, 29 Sep 2022 04:41:13 GMT

@D19PAL wrote: Portal4me Login

Hi,

How do i get this count in a table

Data

Name, Manager,ID,Class,Position

John,james,1,art,student

Dan,james,2,art,student

James,simon,3,art,teacher

Tony,peter,4,art,student

I need to count by position, how many Name and Manager have the same Class,

So group 1 is Class Art John and Dan share a class with their Manager, so I want to show John, Dan and the Manager James.

Table

Class,Position,Total

art,student,2

art,teacher,1

Table 2

ID,Name,Class,Count

1, john,art,1

2, Dan,art,1

3,James,art,1

Thanks much appreciated

I appreciate the information and advice you have shared. I will try to figure it out for more.

Re: How do i get this count in a table

D19PAL — Wed, 28 Sep 2022 14:25:35 GMT

Hi Ryan,

Any luck with this?

Thanks