topic Type Mismatch Error on MonthEnd Function in Macro in QlikView

Type Mismatch Error on MonthEnd Function in Macro

shumailh — Thu, 07 Jul 2011 06:10:48 GMT

I am using below macro and getting type mismatch error on MonthEnd Fucntion while executing macro on onSelect Field Event Below is a Macro.

sub Update_PrevMonth()
Set v = ActiveDocument.Variables("PrevMonth")
v.setcontent MonthName(MonthEnd(LoadDate_Active-Day(LoadDate_Active))), true
end sub

Can anyone please help?

Regards

Shumail Hussain

Reference :http://community.qlik.com/message/83724#83724

Type Mismatch Error on MonthEnd Function in Macro

kaushiknsolanki — Thu, 07 Jul 2011 06:18:39 GMT

HI,

This is because you are using Monthend() function which is not a valid vbscript function.

This function is available in qlikview. And you can not use qlikview functions in Macros.

Try some other logic.

Regards,

Kaushik Solanki

Type Mismatch Error on MonthEnd Function in Macro

shumailh — Thu, 07 Jul 2011 06:34:03 GMT

Thanks Man, That was a silly mistake.... now i need to go to some vbscript forum 😞 to get the month end function as i am not good in programming stuff