Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need your help pleeeassee
I created a qlikview variable and I like to it integrate in a R function but it doesnt work ... The conexion between R and QV
Sub Aprofamm
Set myTable=ActiveDocument.GetSheetObject("DATA")
myTable.Export CurrentPath&"/Simulation/Test.csv",",",0
'Create a COM object representing R
Set R = CreateObject("StatConnectorSrv.StatConnector")
R.Init "R"
R.EvaluateNoReturn "source('"&CurrentPath&"/TEST.R')" # CODE R
R.EvaluateNoReturn"COT=Nbre_Cotisant_Regime(base_Cotisant=Base_Cotisant,base_Flux=taux_entree,Age_ret=!!!!!!!!!!!!,N=1,Nouv_Cotisant=5000,t=1)" #Varaible Age_RET should have the QV library
'Close R connection
R.close
End Sub
Function CurrentPath()
Set v = ActiveDocument.GetVariable("vAppPath")
CurrentPath = Replace(v.GetContent.String,"\","/")
End Function
Function Variable() #Read the qlik view variable
Set v = ActiveDocument.GetVariable("Age_RET")
Variable = CInt(v.GetContent().String)
End Function
Help me pleaeeeeeeee
Hi,
did you tryed to monitor execution of this script?
Do you know where exactly is the problem?
regards
Darek