topic Error in Expression: if takes 2-3 parameters in QlikView

Error in Expression: if takes 2-3 parameters

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a straight table with a number of dimensions, one is calculated dimension to only include items that start with F.

I have added an expression to calculate the quantity this is a simple addition of 2 fields. When I refresh the presentation I don't have a problem.

However, I need to create another expression work out the invoice amount which is [Inv Qty]*[Sales Unit Price]. The expression editor says that there is an error in the expression and when the reports runs I get the error" Error in Expression: if takes 2-3 parameters. Even though it is not an if statement.

Any help would be appreciated as this is driving me made

Re: Error in Expression: if takes 2-3 parameters

vishsaggi — Wed, 21 Jun 2017 13:09:05 GMT

Can you show us the expressions you are using ?

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 13:55:39 GMT

Sorry

Inv Qty is [Inventory Free Quantity]+[Inventory Reserved Quantity]

and

The price is [Inv Qty]*[Sales Unit Price]

in the second I get a message saying "Errors in expression"

Re: Error in Expression: if takes 2-3 parameters

ahaahaaha — Wed, 21 Jun 2017 14:01:56 GMT

Hi,

May be Sum( [Inv Qty]*[Sales Unit Price])

Re: Error in Expression: if takes 2-3 parameters

vishsaggi — Wed, 21 Jun 2017 14:04:11 GMT

Can you send me the snapshot where its throwing the error? Are Inv qty and Sales unit price fields from a table or labels from other expressions? I need to know where exactly you are using these.

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 14:08:44 GMT

Inv Qty is an expression that I have built

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 14:09:33 GMT

same issue still says it's an error

Re: Error in Expression: if takes 2-3 parameters

vishsaggi — Wed, 21 Jun 2017 14:18:43 GMT

Can you share the expression you have for this [Inv Qty]? Hmmm not sure why it is throwing error. BTW what error is that can you take a snapshot of that actual error msg?

Re: Error in Expression: if takes 2-3 parameters

awhitfield — Wed, 21 Jun 2017 14:19:04 GMT

Hi Dave,

any chance that you could upload an example QVW?

Andy

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 14:20:19 GMT

no company policy, not even using the scrambler

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 14:35:16 GMT

INV QTY is [Inventory Free Quantity]+[Inventory Reserved Quantity]

Re: Error in Expression: if takes 2-3 parameters

awhitfield — Wed, 21 Jun 2017 14:37:51 GMT

So what the syntax being used in this bit: one is calculated dimension to only include items that start with F.

Andy

Re: Error in Expression: if takes 2-3 parameters

vishsaggi — Wed, 21 Jun 2017 14:38:15 GMT

Are those the fields from the table or some other expression labels. May be try like:

= RangeSum(Sum([Inventory Free Quantity]), Sum([Inventory Reserved Quantity]))

Label this as [INV QTY]

= [INV QTY] * Sum([Sales Price Unit])

Something like this?

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 14:46:16 GMT

=if([Item Code] like('f*'),[Item Code])

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 14:48:42 GMT

[Inventory Free Quantity], [Inventory Reserved Quantity] and [Sales Unit Price] are all from tables

Re: Error in Expression: if takes 2-3 parameters

vishsaggi — Wed, 21 Jun 2017 14:49:53 GMT

You still getting the same error?

Re: Error in Expression: if takes 2-3 parameters

zebhashmi — Wed, 21 Jun 2017 14:50:47 GMT

Try this

=([Inventory Free Quantity]+[Inventory Reserved Quantity])*[Sales Unit Price]

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 15:19:25 GMT

This doesn't bring an error back in the expression but get the same Error in Expression: if takes 2-3 parameters

Re: Error in Expression: if takes 2-3 parameters

vishsaggi — Wed, 21 Jun 2017 15:25:55 GMT

There is an if statement somewhere it is picking up. do you have any other statements other than this expression in that? can you check scrolling down or up? I mean maximize your edit script expression and see if there are any other expressions hidden? Else can you send us the snapshots of those two expressions.

Re: Error in Expression: if takes 2-3 parameters

Wed, 21 Jun 2017 15:40:57 GMT

still doesn't like the expression Inv Qty