topic Re: How to Sum off categories inside a column in QlikView

How to Sum off categories inside a column

Wed, 18 Mar 2015 17:39:22 GMT

Question -

I have some HR data coming in and I need to create a chart that shows the sum of all IT Team Members. Currently my data is coming in as follows. How can I create a chart that shows only the count of IT-Team Member? I also have a month field that would be used as my Dimension.

Person Type	Count
Team Member	30
IT-Team Member	5
IT-Contractor	2
Contractor	10

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 17:40:05 GMT

I guess the better question is how can I write the expression, I know how to create a chart....

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 17:42:27 GMT

How many members are there in the IT team. If it is not a lot then you can hard code them in set analysis.

Thanks

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 17:44:49 GMT

At the moment there are 200 or so but it changes every month.

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 18:00:30 GMT

I mean how many person types.

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 18:02:28 GMT

There are only 4 different person types. Team Member, IT-Team Member, IT-Contractor, and Contractor.

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 18:07:52 GMT

count({<[Person Type]={'IT-Contractor', 'IT-Team Member'}>} [Person Type])

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 18:12:47 GMT

That is close but that returns the count of the appearance of IT-Team Member and IT-Contractor. I need the sum of the count field for every line where the person type is IT-Team Member or IT-Contractor. They could be separate from each other.

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 18:13:52 GMT

I think this might be it.

Sum({<[PersonType]={'IT-Team Member'}>} [CountOfTEXID])

Re: How to Sum off categories inside a column

Wed, 18 Mar 2015 18:16:07 GMT

Or Sum({<[PersonType]={'IT-Team Member'}>} [Count])