topic Re: how to count data based from a chart expression generated result in QlikView

how to count data based from a chart expression generated result

Anonymous — Thu, 07 Dec 2017 16:42:49 GMT

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

Re: how to count data based from a chart expression generated result

Anil_Babu_Samineni — Mon, 11 Dec 2017 09:31:11 GMT

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, ...))

Re: how to count data based from a chart expression generated result

Anonymous — Fri, 15 Dec 2017 01:50:14 GMT

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

Re: how to count data based from a chart expression generated result

sunny_talwar — Fri, 15 Dec 2017 12:46:55 GMT

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