topic Re: Script error: Error in expression:If takes 2-3 parameters in QlikView

Script error: Error in expression:If takes 2-3 parameters

Thu, 16 Jul 2015 09:31:36 GMT

I get the following error:

Error in expression:If takes 2-3 parameters....

Below is the code in the load script. I see the red "(" but cannot get it to work if i add another closing bracket

if("Sale Finalized" = 'Yes', ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]),
if("Sale Finalized" = 'No',
if(("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer = 'Fruit Pool'), ([FOB?EXW]*0.04),([FOB?EXW] * 0.08),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'Ex Works' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price" - ([L-Transport]*[No Cartons])-
([L-Insurance]*[No Cartons]) - ([L-Marine Insurance]*[No Cartons])),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'CIF' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'FOB' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'DIP' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Consignment' , ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons])))))))) as Profit

Please help!!!

Re: Script error: Error in expression:If takes 2-3 parameters

sushil353 — Thu, 16 Jul 2015 09:38:31 GMT

Hi,

Try this:

if("Sale Finalized" = 'Yes', ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]),

if("Sale Finalized" = 'No',if(("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer = 'Fruit Pool'), ([FOB?EXW]*0.04),([FOB?EXW] * 0.08)),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'Ex Works' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price" - ([L-Transport]*[No Cartons])-

([L-Insurance]*[No Cartons]) - ([L-Marine Insurance]*[No Cartons])),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'CIF' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'FOB' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'DIP' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),

if("SubSale Deal Type Text" = 'Consignment' , ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]))))))))

HTH

Sushil

Re: Script error: Error in expression:If takes 2-3 parameters

qlikmsg4u — Thu, 16 Jul 2015 09:38:39 GMT

Seems you lost here in your exp, here true and false both evaluating so that the expression ends here, please try to evaluate once you expression

else post an sample app to look into it with expected outut

if("Sale Finalized" = 'Yes', ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]),
if("Sale Finalized" = 'No',
if(("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer = 'Fruit Pool'), ([FOB?EXW]*0.04),([FOB?EXW] * 0.08),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'Ex Works' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price" - ([L-Transport]*[No Cartons])-
([L-Insurance]*[No Cartons]) - ([L-Marine Insurance]*[No Cartons])),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'CIF' , ("ExWorks Selling" - "Exworks CostX" -"L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'FOB' , ("ExWorks Selling" - "Exworks CostX"- "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'DIP' , ("ExWorks Selling" - "Exworks CostX"- "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Consignment' , ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons])))))))) as Profit

Re: Script error: Error in expression:If takes 2-3 parameters

Anonymous — Thu, 16 Jul 2015 09:38:53 GMT

The bit is red below is an if with 4 parameters, which will give the error you are getting.

if("Sale Finalized" = 'Yes',

([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]),

if("Sale Finalized" = 'No',

if( ("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer = 'Fruit Pool'),

([FOB?EXW]*0.04),

([FOB?EXW] * 0.08),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'Ex Works' ,

("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price" - ([L-Transport]*[No Cartons])-([L-Insurance]*[No Cartons]) - ([L-Marine Insurance]*[No Cartons])),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'CIF' ,

("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'FOB' ,

("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),

if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'DIP' ,

("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),

if("SubSale Deal Type Text" = 'Consignment' ,

([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]))))))))

as Profit

Re: Script error: Error in expression:If takes 2-3 parameters

alexandros17 — Thu, 16 Jul 2015 09:40:01 GMT

The mistake begins at the row:

if(("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer = 'Fruit Pool'), ([FOB?EXW]*0.04),([FOB?EXW] * 0.08),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'Ex Works' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price" - ([L-Transport]*[No Cartons])-
([L-Insurance]*[No Cartons]) - ([L-Marine Insurance]*[No Cartons])),

the correct syntax is:

If(condition, Cond.True,

cond.false

)

Re: Script error: Error in expression:If takes 2-3 parameters

Thu, 16 Jul 2015 09:51:35 GMT

That did not work...but I found the problem via te other guys responses...

Re: Script error: Error in expression:If takes 2-3 parameters

Thu, 16 Jul 2015 09:52:01 GMT

yeah,,,lack of sleep makes you type weird stuff

Re: Script error: Error in expression:If takes 2-3 parameters

Thu, 16 Jul 2015 09:55:57 GMT

yeah,,,lack of sleep makes you type weird stuff

Re: Script error: Error in expression:If takes 2-3 parameters

Thu, 16 Jul 2015 09:56:05 GMT

yeah,,,lack of sleep makes you type weird stuff

Re: Script error: Error in expression:If takes 2-3 parameters

Thu, 16 Jul 2015 10:06:54 GMT

and it now looks like this:

if("Sale Finalized" = 'Yes', ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons]),
if("Sale Finalized" = 'No',
if(("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer = 'Fruit Pool'), ([FOB?EXW]*0.04),//([FOB?EXW] * 0.08),
if(("SubSale Deal Type Text"='Consignment') and ("Sale Deal Type Text" = 'Consignment') and (Producer <> 'Fruit Pool'), ([FOB?EXW]*0.08),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'Ex Works' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price" - ([L-Transport]*[No Cartons])-
([L-Insurance]*[No Cartons]) - ([L-Marine Insurance]*[No Cartons])),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'CIF' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'FOB' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Fixed' and "Selling Cost Type" = 'DIP' , ("ExWorks Selling" - "Exworks CostX" - "L-FinanceX" - "L-AdminX" - "Fixed Purchase Price"),
if("SubSale Deal Type Text" = 'Consignment' , ([L-Idea Commission] * [No Cartons]) + ([L-Margin]*[No Cartons])))))))))) as Profit