topic Re: To get data for max date when no date is selected in the filter in App Development

To get data for max date when no date is selected in the filter

Saurabh07 — Thu, 08 Oct 2020 08:06:22 GMT

I am trying to get sum of values in my table for the latest available date when no date is selected in filter.

I am using below expression, but somehow its not working;

sum({<date = {$(=max(date))}>}Value)

Can anyone please help me out with this?

Re: To get data for max date when no date is selected in the filter

Taoufiq_Zarra — Thu, 08 Oct 2020 09:31:55 GMT

@Saurabh07 check the date format or format it directly In set for example if your date format is DD.MM.YYYY

=sum({$<date={"$(=Date(Max(date),'DD.MM.YYYY'))"}>} Value)

Re: To get data for max date when no date is selected in the filter

Saurabh07 — Thu, 08 Oct 2020 09:56:44 GMT

Hello @Taoufiq_Zarra ,

Thank you for the reply, the date format seems to be fine. The error I am getting is 'Error in set modifier as hoc element: ',' or ')' expected.

The expression is getting evaluated in the expression editior, at the bottom preview shows:

Sum({<date = {30.06.2020}>} Value), which is exactly what I need here. But this error!!!!!

Re: To get data for max date when no date is selected in the filter

Taoufiq_Zarra — Thu, 08 Oct 2020 10:00:02 GMT

@Saurabh07 the SET DateFormat='DD.MM.YYYY' ?

Re: To get data for max date when no date is selected in the filter

Saurabh07 — Thu, 08 Oct 2020 14:35:12 GMT

@Taoufiq_Zarra Why would Dateformat matter in this case. I just want to pick the latest date available and display the sum for value for it. Correct me if I am misunderstanding something here?

Re: To get data for max date when no date is selected in the filter

Taoufiq_Zarra — Thu, 08 Oct 2020 14:41:16 GMT

@Saurabh07 can you share a sample data ?

Re: To get data for max date when no date is selected in the filter

Saurabh07 — Thu, 08 Oct 2020 15:44:30 GMT

@Taoufiq_Zarra Attached is the sample dataset. Hope this helps.

I have a filter to select the date at the top. So whenever any date is selected exclusively the sum of value should be displayed for that particular date. But when nothing is selected in Date filter, the sum of values should be displayed for latest (i.e. Max) date.

Re: To get data for max date when no date is selected in the filter

Taoufiq_Zarra — Fri, 09 Oct 2020 09:33:38 GMT

@Saurabh07

=sum({$<Date={"$(=Date(Max(Date),'DD/MM/YYYY'))"}>} Value)

output:

when i selected a Date:

Re: To get data for max date when no date is selected in the filter

Saurabh07 — Fri, 09 Oct 2020 11:59:45 GMT

@Taoufiq_Zarra Thanks for the expression. Even I worked and developed the mentioned expression;

sum({<date={"=date=Max(total date)"}>}Value)

Does this look correct to you, it is working as per my requirement!

Re: To get data for max date when no date is selected in the filter

Taoufiq_Zarra — Fri, 09 Oct 2020 12:06:42 GMT

@Saurabh07 yes its correct !

Re: To get data for max date when no date is selected in the filter

Saurabh07 — Fri, 09 Oct 2020 12:39:27 GMT

@Taoufiq_Zarra Great, thanks for the help! Appreciate that!