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
Hi Sire Mangal,
Result is "0"
Can you post the application?
Hi Anil,
I am using QBAR
Quickbooks Advanced Reporting
The function is Qlik-View.
Even though, You are building thru Qlikview only, Right? So then please create sample qvw and share with us that may useful to you
what is expression for age and openbalance?
Dear ,
Both of following expression working for me please check also make one setting in Presentation tab -->uncheck Suppress Zero-Values. If it doesn't work plz send dummy data.
sum(aggr(sum({<age={">=0<=30"}>}OpenBalance)*1+
sum({<age-={">=0<=30"}>}OpenBalance)*0,[CustomerName],age))
OR
sum(aggr(if(age>=0 and age<=30 ,sum(OpenBalance)*1,sum(OpenBalance)*0),[CustomerName],age))
have you tried setting it should work.
Provide attach file sample data
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),
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])))