5 Replies Latest reply: Apr 5, 2017 5:35 PM by Erick Dameron RSS

    Creating Aging Dimension

    Erick Dameron

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