18 Replies Latest reply: Nov 4, 2014 11:30 AM by GandalfGray RSS

    How to create a batch file

      Hi

       

      Can some tell me how to develop a batch file??

       

      I want to create one batch file for reading data from file say 'file.txt' and this  'file.txt' contains user information like username, his/her ID, name of the application he/she has accessed etc.

       

       

      Regards

      Avantika

        • Re: How to create a batch file
          Miguel Angel Baeyens de Arce

          Hi Avantika,

           

          For batch file do you mean a Windows batch file? If so, is it going to be read from QlikView? Or do you mean you want to create a batch file to schedule a task to reload a QlikView file that reads from a third file? In this case, the answer is put this line (modified if any according to your folders) in an empty .BAT file

           

          "C:\Program Files\QlikView10\qv.exe" /r "C:\File.qvw"
          

           

          Hope that helps.

           

          Miguel Angel Baeyens

          BI Consultant

          Comex Grupo Ibérica

          • How to create a batch file
            Pradeep Kushwaha

            Hi All,

             

            My problem is similer to above one but small difference.

             

            i want to write a bat who can create new instance. below attached code is .vbs code.

            once i run below  vbs scriptit tookover existing qv instance.

             

            set Qv = CreateObject("QlikTech.QlikView")
            set shell = createobject("wscript.shell")

            success = shell.appactivate("Qlikview - [Start Page]")
            Set docObj = Qv.OpenDoc("E:\QlikView\test.qvw,3,false)

            docObj.Reload
            docObj.Save
            Set docObj= Nothing
            Set Qv= Nothing

             

            My problem is  is there any way to open new instance for any reload.

            • How to create a batch file
              Pradeep Kushwaha

              Hi All,

               

              My problem is similer to above one but small difference.

               

              i want to write a bat who can create new instance. below attached code is .vbs code.

              once i run below  vbs scriptit tookover existing qv instance.

               

              set Qv = CreateObject("QlikTech.QlikView")
              set shell = createobject("wscript.shell")

              success = shell.appactivate("Qlikview - [Start Page]")
              Set docObj = Qv.OpenDoc("E:\QlikView\test.qvw,3,false)

              docObj.Reload
              docObj.Save
              Set docObj= Nothing
              Set Qv= Nothing

               

              My problem is  is there any way to open new instance for any reload.