Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
in qliksense i want create a master item for this?
Count({$<E.Team=>}E.Name)
What kind of master item? Dimension,measure or visualization (which visualisation)
either measure or dimension
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.
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.