Show Aging

[Anonymous]

Hi,

I am looking to show open PO aging like the below image, the formula is simple PO creation date - today(), how do I get it to show it in the following image?

The image is from a qlikview dashboard.

Thanks,

[sunny_talwar]

May be Buckets

[Anonymous]

Hi Sunny,

I am trying the following based on what you suggested but it's giving an error, any thoughts?

if([Estimated Implementation Date] - Today() < 0 and >= -15, '0-15'), if([Estimated Implementation Date] - Today() < -15 and >= -30, '16-30'),
if([Estimated Implementation Date] - Today() < -31 and >= -60, '31-60', 'Greater than 60'))) as Aging

[sunny_talwar]

You have to list your condition each time for and/or

if([Estimated Implementation Date] - Today() < 0 and [Estimated Implementation Date] - Today() >= -15, '0-15'),

[Anonymous]

Thanks buddy, it works

Cheers

[sunny_talwar]

Please close this thread by marking correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks,

Sunny