Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

skh
Contributor

% Outstanding in Day Buckets

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

2 Replies
sushil353
Honored Contributor II

Re: % Outstanding in Day Buckets

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

skh
Contributor

Re: % Outstanding in Day Buckets

Thanks Sushil,

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

Thanks,

Sunil

Community Browser