Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

multiple counts in a single field

I have table like these..

E.ID, E.Name, E.Team

1, hari, HR

2, Narsi, SALES

3, Teaj, HR

4, Kesav, HR

5, Venkat, IT

6, Subbu, IT

7, Lokesh, IT

8, Ktr, IT

9, Naresh, SALES

10, Suji, ACCOUNT ;

count of employee by E.Team

16 Replies
Kohli
Creator II
Creator II
Author

in qliksense i want create a master item for this?

kkkumar82
Specialist III
Specialist III

test.png

ramkrishna86
Creator II
Creator II

Count({$<E.Team=>}E.Name)

DavidŠtorek
Creator III
Creator III

What kind of master item? Dimension,measure or visualization (which visualisation)

Kohli
Creator II
Creator II
Author

either measure or dimension

DavidŠtorek
Creator III
Creator III

OK, than just create table as I suggested or use other functions suggested by others and than create master item in simple way as either Sum(Employee Count) or dimension like only Employee Count.

pablolabbe
Luminary Alumni
Luminary Alumni

Don't forget !


When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.