Type Mismatch while testing the macro

[Anonymous]

Hi,

   I am getting error while testing the macro in the qlikview.I wanted to set start date and end date variables which are used to filter my dataset.

Sub SetClearState_Dashboard()

     Set vStartDate = TODAY()

     Set vEndDate = TODAY()-366

End Sub

Type mismatch: 'TODAY'

Thanks

Dasu.G

[kaushiknsolanki]

Hi,

     Use LET instead of Set.

sub date1(Date1)

Let ABC = Date1 - 365;

ENDSUB


Call date1(today())

Regards,

Kaushik solanki

[Anonymous]

I am trying to achieve this in vb macro.. There I am getting this erorr.. Not in the Qlikview script. Any idea in vb  macro how can we do this?

[kaushiknsolanki · Accepted solution]

Try this,

     sub Test

          set v = ActiveDocument.GetVariable("Variable1")

          v.SetContent date(),true

          set v1 = ActiveDocument.GetVariable("Variable2")

          v1.SetContent date()-365,true

     End sub

Regards,

Kaushik Solanki