topic Re: Count Error in QlikView

Count Error

pavansonu99 — Sun, 05 Nov 2017 16:16:17 GMT

Hi,

i have data like this

i am taking pie chart

QualificationCatagery as Dimension

and expression like this

=count(If(Aggr(NODISTINCT Max(QualToDate), EmployeeNo) = QualToDate, EmployeeNo))

result is coming like this

this values are correct ...

when i select anything like one "Bachelor"

count is coming like this

please help me.

Re: Count Error

sunny_talwar — Sun, 05 Nov 2017 19:21:35 GMT

May be try this

=Count(DISTINCT Aggr(If(Max(TOTAL <EmployeeNo, QualificationCategory> QualToDate) = QualToDate, EmployeeNo), QualificationCategory, EmployeeNo, QualToDate))

Re: Count Error

pavansonu99 — Sun, 05 Nov 2017 19:45:41 GMT

it is showing values like this. even before selection

Re: Count Error

sunny_talwar — Sun, 05 Nov 2017 20:52:59 GMT

Just showing 1 qualificationcategory?

Re: Count Error

pavansonu99 — Mon, 06 Nov 2017 03:19:49 GMT

even full chart showing same result

Re: Count Error

sunny_talwar — Mon, 06 Nov 2017 09:37:13 GMT

and why do you think this number is not correct for Bachelor? Would you be able to share a sample of your app to check this out?

Re: Count Error

pavansonu99 — Mon, 06 Nov 2017 09:58:39 GMT

for example i have 2 emp

emp1 have done bachelor and masters

and

emp2 done only bachelor

if i take pie chart baser on qualification

i will get 1 record under bachelor and i record under masters.

if i click on bachelor dimension in pie chart i will get 2 values because both emp done bachelor

.i want emp with highest qualification. evan i click on qualification dimension did you got it .

in the above chart 2925 is the value which have employees who have done bachelor and other higher qualifications i have to calculate emp highest degree according to QualDate

Re: Count Error

sunny_talwar — Mon, 06 Nov 2017 12:11:22 GMT

How about this then

=Count(DISTINCT Aggr(If(Max(TOTAL <EmployeeNo> QualToDate) = QualToDate, EmployeeNo), QualificationCategory, EmployeeNo, QualToDate))