Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sunnysahni
Creator
Creator

Show Aging

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,

5 Replies
sunny_talwar

May be Buckets

sunnysahni
Creator
Creator
Author

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

sunnysahni
Creator
Creator
Author

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