topic Re: Nested IF Statement to create Bandings in QlikView

Nested IF Statement to create Bandings

kelly_oakley — Sat, 16 Nov 2024 21:36:53 GMT

Hi,

I wonder if you can help me. I am trying to get Qlik to look at values of Items and put them into Bandings.

I have created a Nested If statement but Qlik is coming up with Error in Expression.

What am I doing wrong?

=if(JobPartCostAmount<80,'Less than £80',
if(JobPartCostAmount>80.01 and JobPartCostAmount<300),'£80-£300',
if(JobPartCostAmount>300.01 and JobPartCostAmount<600),'£300-£600',
if(JobPartCostAmount>600.01 and JobPartCostAmount<900),'£600-£900',
if(JobPartCostAmount>900.01,'Greater than £900'))

Thanks

Re: Nested IF Statement to create Bandings

sunny_talwar — Fri, 11 Jan 2019 12:15:05 GMT

Try this

=If(JobPartCostAmount < 80, 'Less than £80',
 If(JobPartCostAmount < 300, '£80-£300',
 If(JobPartCostAmount < 600, '£300-£600',
 If(JobPartCostAmount <= 900, '£600-£900',
 If(JobPartCostAmount > 900.01, 'Greater than £900')))))

Re: Nested IF Statement to create Bandings

kelly_oakley — Fri, 11 Jan 2019 12:27:42 GMT

Hi Sunny,

You are an absolute star thank you so much