topic multiple if condition Expression in QlikView

multiple if condition Expression

Thu, 05 Nov 2015 10:54:27 GMT

Hello all,

I need your help to solve my problem :

my expression is : if(isnull(Budget),SUM(Budget_C)- SUM(Budget), SUM(Budget) - SUM(Budget_C))

i need to add a condition in this expression: when the difference SUM(Budget_C)- SUM(Budget) is less than 0.25, i put 0 else i let the value found of SUM(Budget_C)- SUM(Budget), and the same for the second difference

SUM(Budget) - SUM(Budget_C).

Thank you for your help!

Re: multiple if condition Expression

tamilarasu — Thu, 05 Nov 2015 13:51:19 GMT

Hi Sinhaam,

You can try,

if(isnull(Budget),if(Sum(Budget_C)- Sum(Budget)<0.25,0,Sum(Budget_C)-sum(Budget)), if(Sum(Budget) - Sum(Budget_C)<0.25,0,sum(Budget)-sum(Budget_C)))

Not tested. let me know..

Re: multiple if condition Expression

sunny_talwar — Thu, 05 Nov 2015 13:55:35 GMT

So if Budget is null, Sum(Budget) should be 0. May be try this:

If(Len(Trim(Budget)) = 0,

If(Sum(Budget_C) < 0.25, 0, Sum(Budget_C)),

If((Sum(Budget) - Sum(Budget_C)) < 0.25, 0, (Sum(Budget) - Sum(Budget_C))))

Re: multiple if condition Expression

tamilarasu — Thu, 05 Nov 2015 14:08:46 GMT

Yes Sunny. I too thought the same.. but i dont know what he is trying to do.. Let us wait for the reply..

Re: multiple if condition Expression

Thu, 05 Nov 2015 15:56:23 GMT

it's works, thank you for your help !