topic Re: Macro Help in QlikView

Macro Help

Mon, 03 Dec 2012 17:40:29 GMT

Re: Macro Help

diegofcaivano — Mon, 03 Dec 2012 20:53:38 GMT

Hi. I would recommend you to keep the VBScript code as light and simple as possible, so try to calculate the result in a QlikView variable first.

In this case create a new variable:

=[Field 1] & PURGECHAR($(Variable1), '/') & [Field 2] & CHR(13)

The 'Carriage Return' here is the 13th ASCII non-printable character.

Regards.

Re: Macro Help

Thu, 14 Mar 2013 11:17:03 GMT

Hi Diego,

To do so, i declared a variable in my scipt, but how can i use it in the macro

Something like

x = vName

msgbox vName

doesn't display my variable

I hope you can help

best regards

chris

Re: Macro Help

diegofcaivano — Thu, 14 Mar 2013 12:42:44 GMT

Chris,

To get a QlikView variable at macro runtime, you need:

ActiveDocument.Variables("vName").GetContent.String

Cheers,

Diego.-

Re: Macro Help

Thu, 14 Mar 2013 14:40:41 GMT

Diego,

Thank you very much for your quick answer.

Do you know how i can add a suffix to a filename.

I use Filename = ActiveDocument.Evaluate("replace(documentname(), '.qvw', '.xml')") to get a .xml file named after qvw but i'd like to add a country code like DocName_FR.xml, DocName_SP.xml according to the selected country.

best regards

Chris