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
rubenmarin

Being moderated:

arulsettu
Master III
Master III
Author

you mean do i need to change date format here?

date(Floor(MP_APPR_DT)) as APPROVED_DATE

rubenmarin

Not that, your qvw sample has data until 09/10/2015, meanwhile your query ask data until 09/29/2015, maybe in those 19 days is the difference

arulsettu
Master III
Master III
Author

i changed in query like this

10-SEP-2015

but no difference getting same result.

my doubt is empid present in multiple age we are taking distinct. because that we are getting less total. i thought.

arulsettu
Master III
Master III
Author

any idea guys?

rubenmarin

Can be possible, but still I can't explain the differences between sample qvw and query results:

arulsettu
Master III
Master III
Author

such a wired issue. i dont know what to do

arulsettu
Master III
Master III
Author

can you please take a look at this issue

Gysbert Wassenaar

swuehl

maxgro

tresesco

Thanks

rubenmarin

Hope one of those elite user helps you, meanwhile I would try to match the values for only one age, in example:73

Seems than the query returns 2 more than QV, looking for those two records maybe helps you to find where is the difference.

arulsettu
Master III
Master III
Author

thank you