topic Re: OnOpen Trigger in QlikView

OnOpen Trigger

krishnacbe — Wed, 04 Jul 2012 06:16:58 GMT

I have a created a Document Event Trigger – OnOpen.

Following are the properties

Actions -> Select in Field

Fields -> =date(floor(ExposureDate))

Search String -> =Today()

But this is not working.

My requirement is in a date list box default filter should be current date.

Anonymous — Wed, 04 Jul 2012 06:26:30 GMT

Is ExposureDate a timestamp? Not sure if you can trigger a calculated field like that.

If you do the date conversion of ExposureDate in the script side and just use the resulting date field in the action instead, does this work?

sathishkumar_go — Wed, 04 Jul 2012 07:20:23 GMT

Hi Kriamam,

Just Try this,

Search String -> =max(date(floor(ExposureDate))).

I hope it will helpful for you.

Regards

Sathish