Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have problem on expression syntax. New on using QBAR-QlikView.
if((Age >= 0) and (Age<= 30),OpenBalance*1,0)
Can somebody help me with the code expression.
I think I miss SUM but i dont know the code.
Thanks in advance
I name columns / expression as
Age:
_ReportFilterAsOfDate - Date
OpenBalance:
sum(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])))