Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Well, you already know that you must order it in such a way that when you do the count you can identify where you are going to do it and it is very important to place ID for the names of students and teachers in addition to the classes.
Greetings.
Thanks
Can you send me the code for this please.
LOAD ID_NOMBRE,
NOMBRE_USUARIO,
ID_GERENTE,
NOMBRE_GERENTE,
ID_CLASE,
NOMBRE_CLASE,
ID_POSICION
FROM
[C:\Users\cquezada\Documents\Libro1.xlsx]
(ooxml, embedded labels);
Expresion in qlikview = count(ID_POSICION)