Creating Aging Dimension

[erickd1190]

Hello,

Can anyone help out with this?

Qlik is saying that I need another ')' but I shouldn't

IF("Last Hire Date" >='03/01/2017' AND "Last Hire Date" <'04/01/2017','NewHire',

        IF("Last Hire Date" >='01/01/2017' AND "Last Hire Date" <'03/01/2017','1-3 Months'

              IF("Last Hire Date" >='09/01/2016' AND "Last Hire Date" <'01/01/2017','3-6 Months',

                   IF("Last Hire Date" >='03/01/2016' AND "Last Hire Date" <'09/01/2016','1.5-2 Years',

                       IF("Last Hire Date" >='01/01/2015' AND "Last Hire Date" <'03/01/2016','2 Years',

                          IF("Last Hire Date" >= '01/01/2008' AND "Last Hire Date" <'01/01/2015','2+ Years',

                           'N/A'))))))

[OmarBenSalem]

Where are you putting this?

[erickd1190]

I am using this to create a custom dimension within the Master Items.

[OmarBenSalem]

can you share a sample qvf file to work with?

[OmarBenSalem · Accepted solution]

IF("Last Hire Date" >='03/01/2017' AND "Last Hire Date" <'04/01/2017','NewHire',

        IF("Last Hire Date" >='01/01/2017' AND "Last Hire Date" <'03/01/2017','1-3 Months',// you forgot a comma here

              IF("Last Hire Date" >='09/01/2016' AND "Last Hire Date" <'01/01/2017','3-6 Months',

                   IF("Last Hire Date" >='03/01/2016' AND "Last Hire Date" <'09/01/2016','1.5-2 Years',

                       IF("Last Hire Date" >='01/01/2015' AND "Last Hire Date" <'03/01/2016','2 Years',

                          IF("Last Hire Date" >= '01/01/2008' AND "Last Hire Date" <'01/01/2015','2+ Years',

                           'N/A'))))))

[erickd1190]

I must of looked over this a dozen times and missed that comma.

Thanks for looking at it!