Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can't make chart for debit and credit

I have three tables with numbers and amounts of invoices, payments and shipments. I can't understand, how get right result in the Chart? Should I prepare something in Script. I point yellow Chart that I need.

Thanks for help.

13 Replies
Not applicable
Author

Change the expression function 'Min' to 'MinString' and 'Max' to 'MaxString'.

It wil work.

PayRec.jpg

Not applicable
Author

If I add one more PI# with customer A in table 1, it doesn't work. MaxString and MinString count 2 PI# only for each Customer.

Customer    Proforma Invoice#    Invoice Amount

A    AA    5000

A    AB    7000

B    AC    10000

B    AD    15000

A    AE    5000

Not applicable
Author

It would be easy if you could provide all your requirement at the same time.

For the current requirement you can use the below expresion:

Payables:

=Sum(If(Aggr(Sum([Payment Amount]),[Proforma Invoice#])> Aggr(Sum([Shipment Amount]),[Proforma Invoice#])

, Aggr(Sum([Payment Amount]),[Proforma Invoice#])-Aggr(Sum([Shipment Amount]),[Proforma Invoice#]),0))

Recivables:

=Sum(If(Aggr(Sum([Shipment Amount]),[Proforma Invoice#])> Aggr(Sum([Payment Amount]),[Proforma Invoice#])

, Aggr(Sum([Shipment Amount]),[Proforma Invoice#])-Aggr(Sum([Payment Amount]),[Proforma Invoice#]),0))

Hope this helps.

Not applicable
Author

Thank for your help. I will try to give my questions with right requirements.