Discussion Board for collaboration related to Creating Analytics for QlikView.
Hopefully there is a simple solution for this. I have a batch file that goes like this:
"C:\Program Files\QlikView\QV.exe" /L /VvGroup="Cake" "Path\v2\Demo_Model.qvw"
Echo Party Food Done!
which works perfectly, the model opens, sets the variable and refreshes - as you can see the variable set is vGroup = Cake, but as soon as i set the variable to a string with a gap:
"C:\Program Files\QlikView\QV.exe" /L /VvGroup="Party Food" "Path\v2\Demo_Model.qvw"
vGroup = Party Food
I get an error.
Any ideas on a way around this?
Go to Solution.
I did something similar,
I actually added an underscore to the variable name in the batch file and used a replace formula in the model to get the space back in.
"C:\Program Files\QlikView\QV.exe" /L /VvGroup="Party_Food" "Path\v2\Demo_Model.qvw"
Edit Module in Model:
Set v = ActiveDocument.Variables("vGroup")
vGroup = v.GetContent.String
vGroup = Replace(t, Chr(95), Chr(32))
(....I could then use vGroup when going ahead with my Macro....)
The one way I know is to use additional variable.
and rewrite variable vGroup;