Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pavansonu99
New Contributor III

count going wrong

Hi,

i have data like this

Capture11.PNG

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

Capture1.PNG

this values are correct ...

when i select anything like one "Bachelor"

count is coming like this

Capt1ure.PNG

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