Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
..
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.
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
Chris,
To get a QlikView variable at macro runtime, you need:
ActiveDocument.Variables("vName").GetContent.String
Cheers,
Diego.-
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