Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Ageing report mismatch

Dear All,

I have created one ageing report in that I am getting all data according to user but I am getting proper ageing for one document "EXP/380/16-17" which is also highlighted in attachment.

Please check .

14 Replies
prma7799
Master III
Master III
Author

if you use PostingDate_Bucket then it bifurcating values in both ageing for all document ...

bug.png

Please give some logic or idea that how to achieve the same .

PFA for sample data without bucketing fields

Thanks

prma7799
Master III
Master III
Author

Hi Antonio ,

using your expression the EXP/687/16-17 will come in >180 but in actual it is in 1-180.

antoniotiman
Master III
Master III

prma7799
Master III
Master III
Author

DOC.pngWhat about this???

antoniotiman
Master III
Master III

Min(Posting Date) for this is 31-12-2016