Subtotal - IF Function - SUM - AR Aging

[Anonymous]

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

[Anonymous]

Hi Sire Mangal,

Result is "0"

[Anil_Babu_Samineni]

Can you post the application?

[Anonymous]

Hi Anil,

I am using QBAR

Quickbooks Advanced Reporting

The function is Qlik-View.

[Anil_Babu_Samineni]

Even though, You are building thru Qlikview only, Right? So then please create sample qvw and share with us that may useful to you

[Kushal_Chawda]

what is expression for age and openbalance?

[mangalsk]

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))

[Anonymous]

Hi Mangal Here is the file

Dropbox - AR Aging Detail - V300.zip

Thank you

[Anonymous]

Hi Anil,

Here is the file report.

Dropbox - AR Aging Detail - V300.zip

Thanks.

[mangalsk]

have you tried setting it should work.

Provide attach file sample data

[Anonymous]

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])))