Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have an issue with below formula. What should be done to make it work in qlik sense
=IF(B2<=30,"0-30 days",IF(AND(B2>30,B2<=90),"31-90 days",IF((AND(B2>90,B2<=200)),"91-200 days",IF(B2>200,"more than 201 days","verify"))))
B2=Leadtime
Thanks in advance
Perhaps this
=IF(Leadtime<=30,'0-30 days',
IF(Leadtime>30 and Leadtime<=90,'31-90 days',
IF(Leadtime>90 and Leadtime<=200,'91-200 days',
IF(Leadtime>200,'more than 201 days','verify'))))
Perhaps this
=IF(Leadtime<=30,'0-30 days',
IF(Leadtime>30 and Leadtime<=90,'31-90 days',
IF(Leadtime>90 and Leadtime<=200,'91-200 days',
IF(Leadtime>200,'more than 201 days','verify'))))
Thank you! , I thought it's harder to get it.
Not sure what dimensions you are using, or how you calculate the Leadtime
If Leadtime is a precalculated field in your datamodel use the expression below in your script ( expression AS LeadtimeLabel)
=IF(SUM(Leadtime)='','verify',IF(SUM(Leadtime)<=30,'0-30 days',IF(SUM(Leadtime)<=90,'31-90 days',IF(SUM(Leadtime)=200,'91-200 days','more than 201 days'))))