Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

count going wrong


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.

1 Reply

Re: count going wrong

I think the reason for this behaviour is your max. calculation as condition which also reacts on your selection. Maybe an extention of it with a set analysis to ignore the selections may help, like:

=count(If(Aggr(NODISTINCT  Max({< QualificationCategory = }> QualToDate), EmployeeNo) = QualToDate, EmployeeNo))

- Marcus

Community Browser