topic Document Aging? in QlikView

Document Aging?

Mon, 26 Jan 2026 21:26:37 GMT

I have extracted data from SAP, tables BSIK and BSAK and i would like to age the documents into buckets based on the document date. Buckets that I require are 0-5 days, 6-15 days, 16-30 days, 31-60 days, etc etc

In SQL i would use today-posting date (as an example)...how do I do this in Qlikview?

Re: Document Aging?

Gysbert_Wassenaar — Thu, 03 Oct 2013 15:58:51 GMT

Basically the same way:

Load *,

if(Age<6, '0-5 days', if(Age<16,'5-15 days', if(Age<31,'16-30 days', if.... etc )))) as Bucket;

Load

DocumentID,

PostingDate,

PostingDate - Today() as Age

From ...somewhere...;

Note, if PostingDate isn't a numeric date field but a string you'll have to use the date# function to cast it to a date.

Re: Document Aging?

Fri, 04 Oct 2013 05:37:19 GMT

That is perfect - so glad I was on the right track!