topic Re: Syntax Error in QlikView

Syntax Error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expert,

Can somebody help me with the syntax formula. I dont know whats wrong.?

Thanks

sum({<Age={">=0<=30"}>} If (Transactions.Pending = 0 or IsNull(Transactions.Pending),

if ((Match ([Transactions.Txn Type], 'Receive Payment', 'Credit Memo', 'CreditCardCredit') or (Match ([Transactions.Txn Type], 'Journal') and Match([Transactions.Debit Or Credit], 'Credit'))), -[Transactions.Balance Remaining], [Transactions.Balance Remaining])))

Re: Syntax Error

sunny_talwar — Wed, 19 Jul 2017 14:09:54 GMT

What is the issue? Are you getting an error or incorrect result?

Re: Syntax Error

Anonymous — Wed, 19 Jul 2017 14:15:50 GMT

incorrect result I'm sorry for the term error. I am making aging Thanks

Re: Syntax Error

sunny_talwar — Wed, 19 Jul 2017 14:16:39 GMT

So can you explain in words what exactly this if statement needs to do?

Re: Syntax Error

Anonymous — Wed, 19 Jul 2017 14:46:28 GMT

Hi Sunny,

Thanks

I was trying to edit QBAR - Starter report for Aging please see below snaps.

My problem is Im not getting sum.

this formula works but no sum.

if((Age >= 0) and (Age <= 30),OpenBalance*1,0)

if((Age >= 31) and (Age <= 60),OpenBalance*1,0)

if((Age >= 61) and (Age <= 90),OpenBalance*1,0)

if((Age >= 121),OpenBalance*1,0)

I name columns / expression as

Age:

_ReportFilterAsOfDate - Date

OpenBalance:

sum(If (Transactions.Pending = 0 or IsNull(Transactions.Pending),

the OpenBalance code is from QB.

so i try this/ result is incorrect

sum({<Age={">=0<=30"}>} If (Transactions.Pending = 0 or IsNull(Transactions.Pending),