topic Using sub filed for > or < in If condition? in QlikView

Using sub filed for > or < in If condition?

qlikuser222 — Mon, 06 Nov 2017 19:52:00 GMT

Hi Everyone,

I have a requirement where is need to perform calculations based on range of amount. ( < or >=)

PFA attached file which has sample data . I am unable to achieve the results with if condition and using sub field in it.

Please help me understand the error.

Thanks

Re: Using sub filed for > or < in If condition?

Nicole-Smith — Mon, 06 Nov 2017 20:12:26 GMT

Try changing you Calc1 calculation to:

if(if(SubField(Range,' ',1) = '<', [Paid Amount] < SubField(Range,' ',2), [Paid Amount] >= SubField(Range,' ',2)), [Paid Amount] * Discount),[Paid Amount] * Discount )as Calc1

I've also attached an updated version of your file.