how to count data based from a chart expression generated result

[Anonymous]

In this report, I have an expression column  Current [count(Name) and a Prev [=Count({<[FileWeek]=P(FileWeekPrev)>} [Name]) ]

and type123 If( Current=1 and Prev=0, 'NewHire',
If(Current=0 and Prev=1,'Term', 'Employee')) . Now I want to count how many are New hire and how many term per department.

Is this possible to achieve in QlikView. If not, please give some idea or any possible solution for this kind of requirements.

Thanks, Cy

[Anil_Babu_Samineni]

May be this?

Count(Aggr(If(Count(Name) =1 and Count({<[FileWeek]=P(FileWeekPrev)>} [Name]) = 0, 'NewHire', If(Count(Name) = 0 and Count({<[FileWeek]=P(FileWeekPrev)>} [Name]) = 1, 'Term', 'Employee'), 1,0), FieldName_Dim1, FieldName_Dim2, ...))

[Anonymous]

Thank you Anil for the response but the script is not working. Red lines shows [, 1,0), FieldName_Dim1, FieldName_Dim2, ...))]

[sunny_talwar]

Count this in the chart itself or in a text box object?