Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Re: count for employee and dependent shows incorrect

Being moderated:

arulsettu
Honored Contributor III

Re: count for employee and dependent shows incorrect

you mean do i need to change date format here?

date(Floor(MP_APPR_DT)) as APPROVED_DATE

Re: count for employee and dependent shows incorrect

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

Re: count for employee and dependent shows incorrect

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

Re: count for employee and dependent shows incorrect

any idea guys?

Re: count for employee and dependent shows incorrect

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

arulsettu
Honored Contributor III

Re: count for employee and dependent shows incorrect

such a wired issue. i dont know what to do

arulsettu
Honored Contributor III

Re: count for employee and dependent shows incorrect

can you please take a look at this issue

Gysbert Wassenaar

swuehl

maxgro

tresesco

Thanks

Re: count for employee and dependent shows incorrect

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

Re: count for employee and dependent shows incorrect

thank you