Discussion board where members can get started with QlikView.
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.
To do so, i declared a variable in my scipt, but how can i use it in the macro
x = vName
doesn't display my variable
I hope you can help
To get a QlikView variable at macro runtime, you need:
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.