Combining If statements in load script

Wed, 19 Oct 2011 02:06:24 GMT

Hello,

I`m trying to combine to If statements on a load script for calculation purposes.

Seperately they give good results,

But If I combine using or it generates results at the right values except the generated result is only 1 instead the actual amount

If([Type]=2,IF( "Qty_ to Ship" > 0, "Line Amount")) as RunningSalesLineAmount,

If([Type] =1,If([No_] like '8*',"Line Amount")) as RunningSalesLineAmount,

any help would be appreciated

Wed, 19 Oct 2011 02:43:07 GMT

I found the solution,

It was the if then else function used properly ..

IF( "Qty_ to Ship" > 0,If([Type]=2, "Line Amount",If([Type] =1,If([No_] like '8*',"Line Amount")))) as RunningSalesLineAmount,

topic Combining If statements in load script in QlikView