topic Re: Default Date when clear button selected in QlikView

Default Date when clear button selected

renjithpl — Tue, 25 Sep 2012 05:52:18 GMT

Hi All,

Need a macro or a solution to keep a default date as max date in application when clear button selected.

Regards

Renjith

christophebrault — Tue, 25 Sep 2012 08:52:30 GMT

if i well understood, you have a button that clear all selection ?

If it's that case, just add an action to that button to select your default date in your field Date.

renjithpl — Tue, 25 Sep 2012 10:45:08 GMT

Sub SetClearState_Dashboard()

vDefaultDate1=DATE(Max(Date),'DD/MM/YYYY')

Set defaultDate = ActiveDocument.Variables("vDefaultDate1")
ActiveDocument.Fields("CalDate").Select defaultDate.GetContent.String

ActiveDocument.SetClearState

End Sub

renjithpl — Tue, 25 Sep 2012 11:44:26 GMT

Sub SetClearState_Dashboard()

vDefaultDate1=DATE(Max(Date),'DD/MM/YYYY')

Set defaultDate = ActiveDocument.Variables("vDefaultDate1")

ActiveDocument.Fields("CalDate").Select defaultDate.GetContent.String

ActiveDocument.SetClearState

End Sub