4 Replies Latest reply: Mar 25, 2014 7:50 AM by Peter Cammaert RSS

    Can you call a Qlikview Variable in a Macro?

    Alan Farrell

      Hi All,

       

      I have a Variable called vCustomer

       

      I have a macro that creates a new Qlikview file that I got from the community

       

      SUB createfile

       

      Set Qv = CreateObject("QlikTech.QlikView")

      Set docObj = Qv.CreateDoc

      docObj.SaveAs "C:\Users\alan\Desktop\$(vCustomer).qvw"

      docObj.CloseDoc

      Set docObj = Qv.OpenDocEx (qvwFullPath,0,false)

      docObj.Save

      docObj.CloseDoc

      Qv.Quit

       

      END SUB

       

      I tried adding the Variable vCustomer to save the new Qlikview file as the Customer in my project, but it does not work.

       

      Any suggestions

       

      Regards

       

      Alan