Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

% 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
Master II
Master II

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
Former Employee
Former Employee
Author

Thanks Sushil,

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

Thanks,

Sunil