30, 60, 90 Customised Filter

[ToddE]

Hello Qlik Community

I've built a table (contracts) and one of the dimensions is 'Days to Expiry' (the calculation happens in SharePoint, so it's just a number in Qlik).  As you'd expect, it contains a whole range of numbers.

I'd like to be able to create a filter so the reader can see contracts due to expire in 30 days or less, 31-60 or 61-90, etc.  Something I've seen lots of requests for help with, but nothing that seems as straightforward as my requirement.  Nevertheless, I'm stuck and everything I've tried doesn't work.

I appreciate any help offered...THANK YOU

[vinieme12 · Accepted solution]

create a new field as below

if([Days to Expiry]>90,'>90 Days'

  ,if([Days to Expiry]>60,'61-90 Days'

  ,if([Days to Expiry]>30,'31-60 Days','30 Days'))) as ExpiryBucket

[ToddE]

Thank you Vineeth, that has worked perfectly