2 Replies Latest reply: Jun 1, 2015 10:20 AM by balkumar chandel RSS

    Problem Using SetSymbol Method in Qlikview and R integration ?

      I am working on qlikview and r integration, below i have written a macro which integrate QV and R.But i am facing problems in passing value of a Qlikview variable to my R script. I have used SetSymbol funcion which vb script variable to r variable.

       

       

      sub test

       

      'Asigning the value of a QvVariable to to V

      set v = ActiveDocument.Variables("vQvVariable").GetContent

       

      'Creating rcom object

      set R = CreateObject("StatConnectorSrv.StatConnector")

      R.Init "R"

       

      'creating a varible in r

      R.EvaluateNoReturn "diff<-0"

       

      'Assigning value of v to diff

      R.SetSymbol "v",diff

       

      R.EvaluateNoReturn "c<-576+diff"

      result=R.GetSymbol("c")

      R.close

      ActiveDocument.Variables("vVariableDisplay").SetContent result, true

      MsgBox("Result")

      End Sub

       

      Thanks for the help.