Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))))))
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'))))))
Where are you putting this?
I am using this to create a custom dimension within the Master Items.
can you share a sample qvf file to work with?
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'))))))
I must of looked over this a dozen times and missed that comma.
Thanks for looking at it!