topic Re: Show Aging in QlikView

Show Aging

Anonymous — Thu, 05 Jan 2017 11:18:22 GMT

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,

Re: Show Aging

sunny_talwar — Thu, 05 Jan 2017 11:57:08 GMT

May be Buckets

Re: Show Aging

Anonymous — Thu, 05 Jan 2017 13:27:21 GMT

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

Re: Show Aging

sunny_talwar — Thu, 05 Jan 2017 13:36:16 GMT

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'),

Re: Show Aging

Anonymous — Thu, 05 Jan 2017 14:20:22 GMT

Thanks buddy, it works

Cheers

Re: Show Aging

sunny_talwar — Thu, 05 Jan 2017 22:15:22 GMT

Please close this thread by marking correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks,

Sunny