Sheet Level/Dccument Level Trigger

[#1]

Hi,

I am trying to implement a document level/sheet level trigger which on opening should give only today's data (or the maximum date which is present in the data).I tried going to sheet properties->Triggers->onActivateSheet->Action->Select->

My select in field is OrderDate and selection string is Date(Max(OrderDate),'MM/DD/YYYY').when i do this on opening it should give me only maximum date let it be 15th sep as per my data.Its not working for some reason.If i apply the same on another field like customer number or itemnumber its working absolutely fine.I think there is some error regarding data conversion.But Order Date is in MM/DD/YYYY format.Let me know if anyone have come across this scenario.Your help is appreciated

Thanks,

Navya

[malini_qlikview]

Hi

i could see the alternate state is selected in setting actions. I guess an alternate state is created with OrderDate, hence the trigger is applied on the state created and not to the original field OrderDate. Remove the alternate state in triggers else add a new select in field trigger for OrderDate only.

[#3 · Accepted solution]

Hi Malini,

Using MaxString(OrderDate) worked,error is not w.r.t Alternate State.

Thanks,

Navya