topic Re: Dynamic selection in App Development

Dynamic selection

Maddineni_S — Thu, 30 Jun 2022 12:53:54 GMT

Hello Members,

I have written an expression, by default which should give letest month data "sum({<Year={2022},Month={'May'}>} EX_Data )" but when i select another month from filter it should give the selected month value. can some one guide me to write the expression.

thanks in advance.

Re: Dynamic selection

sergio0592 — Thu, 30 Jun 2022 13:43:45 GMT

Hi,

And if you just try with :

sum({<Year={2022}>} EX_Data )

Re: Dynamic selection

vinieme12 — Fri, 01 Jul 2022 06:12:13 GMT

If no selections are made: This will show latest month and latest year
If a month is selected and not year: This will show selected Month and latest year
if year is selected and not month: This will show latest month for selected year
if year and month is selected: This will show selected month and selected year

=sum({< Year={'$(=Max(Year))'} ,Datefield={">=$(=Date(Monthstart(Max(Datefield))))<=$(=Date(Max(Datefield)))"} >}EX_Data )