Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
some one please suggest some solution. its really urgent.
Thanks
Being moderated:
you mean do i need to change date format here?
date(Floor(MP_APPR_DT)) as APPROVED_DATE
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
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.
any idea guys?
Can be possible, but still I can't explain the differences between sample qvw and query results:
such a wired issue. i dont know what to do
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.
thank you