Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pavansonu99
Creator
Creator

Count Error

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.

7 Replies
sunny_talwar

May be try this

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

pavansonu99
Creator
Creator
Author

it is showing values like this. even before selection

Capt1ure.PNG

sunny_talwar

Just showing 1 qualificationcategory?

pavansonu99
Creator
Creator
Author

even full chart showing same result

123.PNG

sunny_talwar

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?

pavansonu99
Creator
Creator
Author

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

sunny_talwar

How about this then

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