# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:
Creator II

## Student with same company and department

Hi,

I need to count how many students have the same company and department

This is the full outcome.  If I sum flag in a kpi box I'll get 7.

In a straight table, I'll get 7 rows like below.

Form,student,company,dept,flag

4,1122,asda,A,1

5,167,asda,A,1

9,113,asda,A,1

8,167,Foxy,A,1

12,113,Foxy,A,1

6,167,comment,A,1

13,114,comment,A,1

Thanks

Form,student, teacher,company, dept

1,1122,167,tesco,a

2,1122,167,sainsbury,a

3,1122,167,Morrison,a

4,1122,167,asda,a

5,167,113,asda,a

6,167,113,comment,a

7,167,113,taser,a

8,167,113,foxy,a

9,113,167,asda,a

10,113,167,roxy,a

11,113,167,troxy,a

12,113,167,foxy,a

13,114,167,comment,b

14,114,167,black,b

15,114,167,blue,b

16,114,167,red,b

2 Replies

@D19PAL  can you share the expected output

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Creator II
Author

This is the full outcome.  If I sum flag in a kpi box I'll get 7.

In a straight table, I'll get 7 rows like below.

Form,student,company,dept,flag

4,1122,asda,A,1

5,167,asda,A,1

9,113,asda,A,1

8,167,Foxy,A,1

12,113,Foxy,A,1

6,167,113,comment,A,1

13,114,167,comment,A,1

Tags
Community Browser