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: 
arulsettu
Master III
Master III

count for employee and dependent shows incorrect

Hi all,

          i am trying to show the count of employee and dependent by age wise in barchart. but i am getting incorrect values. i checked the data model also.

my approval date format like this

Untitled.png

so i did this in back end to get date

     date(Floor(MP_APPR_DT)) as APPROVED_DATE

from this APPROVED_DATE created master calendar.

while checking in DB the values getting in QV is incorrect.

i dont know what cause the issue.

please check the attached app.

this the expected output for the age range

Untitled.png

some one please suggest some solution. its really urgent.

Thanks

29 Replies
MK_QSL
MVP
MVP

14594
15088
61451
74968
24283
2423

TOTAL 192807



You have total employee

154773

How to match this?

Something wrong !

arulsettu
Master III
Master III
Author

yes Manish bro,

                          that is the issue. while checking in DB i get this 192807. but in QV 154773.

i dont know what is the issue. can you check the issue please.

MK_QSL
MVP
MVP

Comment for all other tables except the ME_AGE and EMPLOYEE ID and try to find out how many Employee_ID you are getting?

arulsettu
Master III
Master III
Author

173714

rubenmarin

Hi Arul, just to confirm... that results you expecting is the number of employees related to one of the 7811 policies approved in 2015?

sujeetsingh
Master III
Master III

Check the data model  linking

arulsettu
Master III
Master III
Author

this is the expected output for year 2015

Untitled.png

arulsettu
Master III
Master III
Author

i did sujeet. something else causing the issue.

rubenmarin

Yes, I wanted to confirm that year is related to policies and policies to employees, so that's the results of the employees related to a policy approved in 2015.

Anyway in your answer to Manish, loading only the employee table you don't get so many employees, it's almost 20.000 employees short. This is weird, as you can't filter year the same way and results should be higher, you commented all other tables like Manish asked? In you sample counts 495.557 distinct employee ID removing year selections

Edit: it was 173.714, forgot I removed the "distinct" for testing.