topic Macro Problem in QlikView

Macro Problem

bharatkishore — Thu, 30 May 2013 06:56:20 GMT

Dear Member,

I have the following Macro

sub calcmin

set min = ActiveDocument.Variables("currentdatemin")

set max = ActiveDocument.Variables("currentdateMax")

set f=ActiveDocument.Fields("E_Date_New")

f.clear

f.Select ">=" + min.GetContent.String + "<=" + max.GetContent.String

end sub

Now when i click on "Test" button means i am getting the following error.

Object required: 'max'

Can you please help me to sort this issue.

Thanks and Regards,

R. Bharat Kishore

Re: Macro Problem

tresB — Thu, 30 May 2013 07:00:01 GMT

it suggests that 'max' variable is got getting value assigned. see if your 'currentdateMax' is right or not.

Thanks.

Re: Macro Problem

bharatkishore — Thu, 30 May 2013 07:04:48 GMT

Thanks for the reply. The value is correct. But When i am running the macro it is executing but the variables are not getting any values. They are showing as Null. I took a calendar object.

Re: Macro Problem

tresB — Thu, 30 May 2013 07:09:44 GMT

Is there any chance you can upload a sample application?

Thanks.

Re: Macro Problem

bharatkishore — Thu, 30 May 2013 07:16:02 GMT

PFA File.

Re: Macro Problem

tresB — Thu, 30 May 2013 07:57:15 GMT

Please find the attachment. I think you missed the variable declaration.

Thanks.

Re: Macro Problem

bharatkishore — Thu, 30 May 2013 08:00:13 GMT

Thank you for your answer. Can you please tell me what i did i miss. Can you tell me the process.

Thanks.

Re: Macro Problem

bharatkishore — Thu, 30 May 2013 08:09:02 GMT

I got it. Thanks a lot and when i am loading the same qvd in the main qlikview my count of one of my field is not coming. I mean if the load qvd count of A is 100. But if i load the same qvd my in my main file then count of A is getting to 50. Can you please tell me where did i do wrong.

Re: Macro Problem

tresB — Thu, 30 May 2013 08:27:25 GMT

its very tought to say without looking at the application where you are having the issue. may be any inner join reducing the records.

Thanks.

Re: Macro Problem

bharatkishore — Thu, 30 May 2013 09:26:01 GMT

I am not using any joins. i am fetching the qvd's only. And the above macro is there. Thats it. But i don't know what was the reason.

Thanks and Regards,

R. Bharat Kishore