always select the first value in mulitibox field.

[#1]

Hi,

i am doing small dashboard which loads every week data into qlikview. I am having one field ReportDate in Multibox. if I select the option "Always select one value", the same value will be selected always.

suppose If i select the value 03/12/2012. I checked option "Always select one value".

if i load next week data i.e 09/12/2012. Then i need to select this date instead of old date.

Thanks

Suresh

[CELAMBARASAN · Accepted solution]

Hi,

     Use on document open trigger in the document properties and use select in field action and set the value as MinString(FieldName)

Celambarasan

[eliran]

Just to make clear of Celambarasan's suggestion, in case your intrested in loading the desired date, I would suggest using the triger with Max.

That's because your intrested in taking the last report date.

So in Field insert: ReportDate

and in selection insert:=Max(ReportDate)

Hope it helps,

Eliran.

[#4]

it's working thanks.