topic Re: How can I sum all records by a specific date entered by the user filter in App Development

How can I sum all records by a specific date entered by the user filter

Sidimar — Wed, 16 Oct 2019 14:41:53 GMT

Good morning everyone, all right?
As stated in the subject, I need to sum all records until a specific date. I found a way to do this at this link.

https://community.qlik.com/t5/QlikView-Creating-Analytics/How-can-i-sum-all-records-until-a-specific-date/m-p/375554#M13483

But there is a detail, the date cannot be predefined, it needs to be informed by the user through the filter.
When the date is entered, it must be used as the maximum date; otherwise, The most recent date must be taken into consideration. How to proceed?
Thank you very much in advance.

Re: How can I sum all records by a specific date entered by the user filter

treysmithdev — Thu, 17 Oct 2019 13:46:32 GMT

I think you are misunderstanding the solution you linked. This solution is dynamic to what date the user selects, there is no predefined date value.

In this formula:

sum({$<Date= {"<=$(=max(Date))"}>} Amount)

Date is a field.

That means the max date value possible in the field Date will be the limit.

Say you have these date values:

Date

01/01/2019

01/09/2019

01/17/2019

01/31/2019

02/01/2019

With no selections the above expression will evaluate to:

sum({$<Date= {"<=02/01/2019"}>} Amount)

This would sum values 01/01/2019 - 02/02/2019

If a user selects '01/31/2019' in the filter, the expression would then evaluate to:

sum({$<Date= {"<=01/31/2019"}>} Amount)

This would sum values 01/01/2019 - 01/31/2019

Re: How can I sum all records by a specific date entered by the user filter

Sidimar — Thu, 17 Oct 2019 18:17:16 GMT

Thank you very much, I really got it wrong when I implemented that it wasn't working. Now yes, thank you very much;