topic Script Wise Subtract in QlikView

Script Wise Subtract

NavinReddy — Wed, 17 Sep 2014 19:02:46 GMT

Dear Experts,

I want to apply Subtract in Script Wise

if [Acct 3]='LOB' i want to subtract [Acct 3]='LOB' - [Acct 6]='CFVTO00049-Tech & Ops Allocations, Internal'

i am writing bellow formula,its not working suggest me is there any way to solve this Issue

IF([Acct 3]='LOB' ,[Acct 3]='LOB'-[Acct 6]='CFVTO00049-Tech & Ops Allocations, Internal',[Acct 3])as [Acct3],

Thanks In Advance

Niranjan

MarcoWedel — Wed, 17 Sep 2014 20:05:54 GMT

can you please post some sample data with description of the expected result?

What do you intend with

[Acct 3]='LOB'-[Acct 6]='CFVTO00049

If it's two logical expressions you like to subtract, then it would be

([Acct 3]='LOB')-([Acct 6]='CFVTO00049)

because of operator priorities.

regards

Marco