topic Dynamic Max Date through Script in App Development

Dynamic Max Date through Script

poojashribanger — Tue, 29 May 2018 04:51:14 GMT

how to get dynamic value in variable.

below code will give me static value but i want my variable to change with respect to date selection.

Temp:

Load

Max(dt) as MaxDate

Resident table_name;

Let vMaxDate = date(Peek('MaxDate',0,'Temp'));

LET vM1=date(yearend('$(vMaxDate)',-1,4),'MMM-YYYY');

LET vM4=date('$(vMaxDate)','MMM-YYYY');

LET vM3=date(monthstart('$(vMaxDate)')-1,'MMM-YYYY');

LET vM2=date(AddMonths(monthstart('$(vMaxDate)'),-2),'MMM-YYYY');

load * inline [

Timeline

'$(vM1)'

'$(vM2)'

'$(vM3)'

'$(vM4)'];

please help.

Re: Dynamic Max Date through Script

RonaldDoes — Tue, 29 May 2018 07:26:59 GMT

Hi Poojashri,

In that case you wouldn't want to define your variable in the script. After all, these only get updated once, during reload.

You'll have to add the variable in the Variable Editor in the frontend.

Please find attached example.

Hope this helps you.

With kind regards,

Ronald

Re: Dynamic Max Date through Script

poojashribanger — Tue, 29 May 2018 07:30:38 GMT

i want to achieve this through backend

Re: Dynamic Max Date through Script

RonaldDoes — Tue, 29 May 2018 07:34:48 GMT

That is fundamentally impossible, since at the time of reload, there is no way of knowing the selection the users are going to make when they eventually open the app.