Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
arulsettu
Honored Contributor 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

Tags (4)
29 Replies
MVP
MVP

Re: count for employee and dependent shows incorrect

14594
15088
61451
74968
24283
2423

TOTAL 192807



You have total employee

154773

How to match this?

Something wrong !

arulsettu
Honored Contributor III

Re: count for employee and dependent shows incorrect

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.

MVP
MVP

Re: count for employee and dependent shows incorrect

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
Honored Contributor III

Re: count for employee and dependent shows incorrect

173714

Re: count for employee and dependent shows incorrect

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
Honored Contributor III

Re: count for employee and dependent shows incorrect

Check the data model  linking

arulsettu
Honored Contributor III

Re: count for employee and dependent shows incorrect

this is the expected output for year 2015

Untitled.png

arulsettu
Honored Contributor III

Re: count for employee and dependent shows incorrect

i did sujeet. something else causing the issue.

Re: count for employee and dependent shows incorrect

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.