topic Nested IF Statement in QlikView

Nested IF Statement

Wed, 25 Jul 2012 14:25:17 GMT

Is it possible to nest an IF statement within another IF statement? So for example for the below... would that be the best way of doing things?

If(Len(NetSalesValue) > 9, 0, NetSalesValue) as [Invoice Value],

if(NetSalesValue < 0, NetSalesValue, 0) as [Credit Value],

I would like to still apply the Invoice Value IF to the Credit Value.

Miguel_Angel_Baeyens — Wed, 25 Jul 2012 14:30:36 GMT

Hi Lewis,

Yes, that's possible indeed and should work just fine in the script. Check this syntax:

If(
  If(Len(NetSalesValue) > 9, 0,NetSalesValue) < 0,
    NetSalesValue, 0) as [Credit Value],

Hope that helps.

Miguel

Wed, 25 Jul 2012 14:33:12 GMT

I think the problem you have is that you have called the NetSalesValue twice... try the formula below..

if(If(Len(NetSalesValue) > 9, 0, NetSalesValue)< 0, NetSalesValue, 0) as [Credit Value],

Or you could use this.

If(Len(netSalesValue)>9 and NetSalesValue<0, NetSalesValue,0) as [Credit Value],

I Hope this helps

Ali

Wed, 25 Jul 2012 15:24:44 GMT

Thanks again Miguel, thats perfect and works a treat!