Error in expression: If takes 2-3 parameters

Wed, 25 Nov 2020 16:16:04 GMT

I have a table with quite a few dimension and 3 expressions.

The result set is based on 3 list box. When I press clear I get this error message:

Error in expression:

If takes 2-3 parameters

However, if I choose details from the list box it works without any issue. If I choose all the entries from the customer list box which will essentially return all the values in the same way as pressing the clear button.

If I disable all the expressions the report doesn't run at all as I am using a straight table. As the error suggest it must be one of my expressions. Can you take a look and see if my expressions wont work using the clear function

1. Inv Qty -

=if([Item Code] like('F*') and LinkId='INVHSTD' and [Sales Order Num]<> Null(),
[Inventory Free Quantity]+[Inventory Reserved Quantity],0)

2. Value-

= if (LinkId='INVHSTD' and [Sales Order Num]<> Null(),
([Sales Unit Price]*[Inv Qty])/[Sales Price Unit Conversion],0)

3.Value Display -

=if (isnull([Value]) and [Item Code] like('F*'), [Inventory Free Value],[Value])

Any help would be gratefully received

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

Sergey_Shuklin — Thu, 25 May 2017 11:35:10 GMT

Hello, Dave!

And what this list box fields are?

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

sunny_talwar — Thu, 25 May 2017 11:44:35 GMT

Would you be able to share a sample to look at this?

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

Thu, 25 May 2017 11:49:30 GMT

my list boxes are customer, sales rep and csr

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

Thu, 25 May 2017 11:50:19 GMT

Sorry I can't...company policy. Madness I know

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

Error in expression: If takes 2-3 parameters

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

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

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

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