topic Re: Expression Error02 in QlikView

Expression Error02

Anonymous — Wed, 02 Dec 2015 09:54:05 GMT

I have two tables like the following picture :

I need to make the amount become with and like the following:

1 – Invoice

2 – Finance Charge

3 – Misc Charge

4 – Return

5 – Credit Memo

6 – Payment

-----------------

I try this expression but it doesn't work!

=if(([R_Document Type]) = 'Credit Memo' & 'Payment',( -1 * ([R_Document Amount])),([R_Document Amount]))

eduardo_sommer — Wed, 02 Dec 2015 10:00:44 GMT

The field name were missing after the and (which in fact shoul be an OR)

Also, the & operand concatenate both strings.

=if([R_Document Type] = 'Credit Memo' OR [R_Document Type] = 'Payment',( -1 * ([R_Document Amount])),([R_Document Amount]))

Eduardo

Anonymous — Wed, 02 Dec 2015 10:02:45 GMT

it's still plus !!

Regards,

PrashantSangle — Wed, 02 Dec 2015 10:09:29 GMT

Hi,

try like

if(wildmatch([R_Document Type],'*Credit Memo*','*Payment*'),-1*[R_Document Amount],[R_Document Amount])

Regards

eduardo_sommer — Wed, 02 Dec 2015 10:12:37 GMT

Where did you put this expression? In the load script or UI Object?

Anonymous — Wed, 02 Dec 2015 10:13:31 GMT

thanks it's working

Kushal_Chawda — Wed, 02 Dec 2015 10:14:38 GMT

try

=if(match(lower([R_Document Type])=,'credit memo', 'payment'),( -1 * ([R_Document Amount])),([R_Document Amount]))