topic Re: Type Mismatch while testing the macro in QlikView

Type Mismatch while testing the macro

Anonymous — Tue, 19 Mar 2013 21:01:12 GMT

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 — Wed, 20 Mar 2013 06:35:42 GMT

Hi,

Use LET instead of Set.

sub date1(Date1)

Let ABC = Date1 - 365;

ENDSUB

Call date1(today())

Regards,

Kaushik solanki

Anonymous — Wed, 20 Mar 2013 11:54:46 GMT

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 — Wed, 20 Mar 2013 11:58:56 GMT

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