topic Re: % Outstanding in Day Buckets in QlikView

% Outstanding in Day Buckets

Sunil_Kenth — Wed, 05 Jun 2013 12:12:02 GMT

Hi,

I would like to display the % outstanding in a text box so that it shows % of total outstanding that is 0-30 days, 31-60 days, 61-90 days, etc.

The fields that i have to work with are:

Documentdate (date the amount is due)

OutstandingValue

Thanks,

Sunil

sushil353 — Wed, 05 Jun 2013 12:15:28 GMT

hi,

you can use setanalysis for that..

first of all using interval match get the outstanding for 0-30 days, 31-60 days, 61-90 days, etc.

after that get the percentage outstanding.

HTH

Sushil

Sunil_Kenth — Wed, 05 Jun 2013 12:24:55 GMT

Thanks Sushil,

Do you have an example, im not sure how i'd use interval match?

Thanks,

Sunil