Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
usamabinsadiq
Contributor III
Contributor III

Need help with due amount calculation

Hi,

I have data fields like: (date field is calculated, it has all the dates from min(order_date) till today)

date,

order_date,

Due_date,

invoice date,

invoice_amount,

customer_name,

.....

 

I need to calculate total due invoice_amount (due_date < date) in master items, can anybody help with it.

 

Thanks.

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
1 Solution

Accepted Solutions
usamabinsadiq
Contributor III
Contributor III
Author

Thank you guys, I resolved it by my own using,

 

sum({<TRX_DUE_DATE={"$(= '<' & max(DATE)) "}>} DISTINCT [INVOICED_SELLING_AMOUNT])

 

but thank you all.

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.

View solution in original post

4 Replies
msKarthikeyan
Employee
Employee

Hi ,

Do u want to calculate due items at customer level?

-Karthik 

usamabinsadiq
Contributor III
Contributor III
Author

yes I want to get customer level, due amount. but amount must be calculated after due date is passed like (due_date < max(date))

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.
lorenzoconforti
Specialist II
Specialist II

According to your data structure there is one date per record so due_date < date will work (technically) but it doesn't look like it is what you are looking for

Can you explain what the date field includes and in which tables does it appear? Do you have a master calendar built on this?

usamabinsadiq
Contributor III
Contributor III
Author

Thank you guys, I resolved it by my own using,

 

sum({<TRX_DUE_DATE={"$(= '<' & max(DATE)) "}>} DISTINCT [INVOICED_SELLING_AMOUNT])

 

but thank you all.

if my replay helped you then please press like button and do not forget to press the "Accept as Solution" button.

View solution in original post