Max date selection issue in Multi box

[dsharmaqv]

Hi All

I have a requirement to select the Max date by default when user opens the qvw document.

To achive this I have enable the trigger option and select the max date. Its working fine but when user click on clear all option, every thing got deselected including date.

How to make date as consistant even after users clicks on clear all option?

Many thanks in Advance!

Deepak Sharma

[sibin_jacob]

always one selected value option is not available in multi box

Try this one

Go to Document Properties-> Trigger tab->

Add-> Select In field->

Give field column like below

=if(GetSelectedCount(Date_Column)=0,'Date_Column')

Search String

=Max(Date_Column)

Click on Okay.

Try to click on Clear ALL

[tresesco · Accepted solution]

PFA

1. OnOpen trigger : =Date(Max({1} Date))

2. OnAnySelect trigger : = Date(Max(Date))