topic Re: Bucket / Ageing Issue in QlikView

Bucket / Ageing Issue

prma7799 — Tue, 30 Jan 2018 06:42:26 GMT

Hi All,

I am not able to achieve ageing for Vendor Analysis. I want to create bucketing on Posting date basis.

Please find the attached QVW with Expected Output.

In calendar object my date format will change in number when I am selecting any date i want it in DD/MM/YYYY

Thanks

Re: Bucket / Ageing Issue

tresB — Tue, 30 Jan 2018 07:26:22 GMT

Though I am not really sure if your expected output is correct or not w.r.t the sample data, try correcting the number format for calendar display and correcting variable vMinDate to VMinDate to make it work. PFA.

Re: Bucket / Ageing Issue

prma7799 — Tue, 30 Jan 2018 07:43:20 GMT

After correction same values are there I want output as attached excel ...

Re: Bucket / Ageing Issue

prma7799 — Tue, 30 Jan 2018 07:45:27 GMT

If you look below in excel you will get bucketing Total that are not matching with your attached qvw

Re: Bucket / Ageing Issue

PrashantSangle — Tue, 30 Jan 2018 12:59:34 GMT

Hi,

try below expression

for 0 to 60 days bucket

=sum({<Posting_Num={">=$(=(vMaxDate-60))<=$(vMaxDate)"}>}Amount)

for 60 to 120 days bucket

=sum({<Posting_Num={">=$(=(vMaxDate-120))<$(=(vMaxDate-60))"}>}Amount)

for >120 days bucket

=sum({<Posting_Num={"<$(=(vMaxDate-120))"}>}Amount)

Regards,

Prashant Sangle

Re: Bucket / Ageing Issue

Anil_Babu_Samineni — Tue, 30 Jan 2018 15:33:54 GMT

Can you provide Excel Formulas as well