topic How can i clear a date variable on open? in QlikView

How can i clear a date variable on open?

hopkinsc — Mon, 04 Oct 2010 09:57:09 GMT

Hi,

I have a date range in my application, START and END.

I cannot seem to clear the START DATE no matter what i try. If i clear all selections, all selections clear apart from START DATE.

When i open the application, The START DATE calender is populated and the END DATE calender is clear.

Does anyone know how i can also get the START DATE calender to clear please?

The variables are vStartDate and vEndDate which are both mapped to TransDate field.

Mon, 04 Oct 2010 11:41:07 GMT

Hi,

You can clear variables using trigger.

Go to Settings > Document Properties > Trigger Tab.

In OnOpen Event Trigger set the vStartDate to blank.

Here's the sample screen:

hopkinsc — Mon, 04 Oct 2010 11:50:47 GMT

Thanks very much 🙂