Dynamic default day selection

[nareshthavidishetty]

Hi am having day level filter as below

here when ever user open the application by default the day filter is should selected yesterday like today is 19th when the user opens the application the day filter should be  18th ( in green) .

Thanks

[tamilarasu · Accepted solution]

You can use triggers like below.

Edit: Use expression as =Day(Today())-1, since you want to select yesterday date.

[PrashantSangle]

Hi,

It should be

Day(Today()-1) not day(Today())-1

because if Today is 1st day of month then your expression will evaluate 0.

Regards

[tamilarasu]

Thank you. It's my mistake.

[jonathandienst]

I usually build my apps in a way that does not require an initial selection. So if i have many days in th model, but need a chart/table representing a day, then I would use a set expression to get the most recent date (Max(ReportDate)). if the user selects a date, than the Max(ReportDate) reflects the user's selection.

That way when the user first opens the app, it selects the most recent date (eg yesterday), but the user can select a date or dates from the date selections and it will show the details according to the user's selections.

I define a variable

Set vMaxDate = '=date(Max(ReportDate))';

Then the expression look like:

=Sum({<ReportDate = {'$(vMaxDate)'}>} Amount)

And no initial date selection is required.

I also usually add vMaxDate to the chart/table captions/titles- eg

='Closing balances - ' & vMaxDate

[nareshthavidishetty]

Thanks,but my requirement is when ever we open the application the day should selected as yesterday  and it should be as below 

[tamilarasu]

Did you try what I suggested.?

[nareshthavidishetty]

sorry i tired that it's not working

[tamilarasu]

It's working fine. Check the attachment.

[sasikanth]

Check the option always one selected values , if you want to hold the selection for that filter

along with the trigger suggested by Nagaraj