topic Re: Passing Values from one QVW to another QVW using Macro in QlikView

Passing Values from one QVW to another QVW using Macro

yasmeenk — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying ODAG in QlikView. I have two apps - One act as selection and another as Responder app.

I am facing an error in the Macro script. Could someone help me out to solve this issue?

Issue - While clicking on "Test" it shows "Object required:'v'"

Note: Already created EDXparms as a Variable and am able to get the selected OrderIDs into that Variable. But I can't reload the Responder Application because of this issue.

Re: Passing Values from one QVW to another QVW using Macro

m_woolf — Thu, 02 Nov 2017 15:04:19 GMT

You might try storing the Var.getcontent.string in a variable and then using that variable in the v.setcontent expression.

Re: Passing Values from one QVW to another QVW using Macro

yasmeenk — Fri, 03 Nov 2017 07:02:11 GMT

Thanks for your response. I have already tried that method. But still no use

Re: Passing Values from one QVW to another QVW using Macro

m_woolf — Fri, 03 Nov 2017 12:10:35 GMT

Can you post a sample qvw showing the problem?

Re: Passing Values from one QVW to another QVW using Macro

yasmeenk — Mon, 06 Nov 2017 05:06:29 GMT

Yes, Am attaching the sample selection app and responder app with Order.xls data.

Re: Passing Values from one QVW to another QVW using Macro

m_woolf — Mon, 06 Nov 2017 13:35:02 GMT

You didn't have EDXparms defined in the ODAQ Qliview qvw.

I made a few changes in your selection macro:

sub selection

set v = ActiveDocument.Variables("EDXparms")

EDXparms = ""

'-- OrderID

set mySelections =ActiveDocument.fields("OrderID").GetPossibleValues

if EDXparms <> "" then EDXparms = EDXparms & chr(124)

EDXparms = EDXparms & "OrderID="

EDXparms = EDXparms & mySelections.Item(0).text

for i = 1 to mySelections.Count - 1

EDXparms = EDXparms & chr(44) & mySelections.Item(i).text

msgbox EDXparms

v.SetContent EDXparms,true

set App=ActiveDocument.GetApplication

set TemplateDoc = App.OpenDoc ("C:\Users\ra053499\Downloads\ODAG Qlikview.qvw","","")

set v = TemplateDoc.Variables("EDXparms")

' msgbox EDXparms

v.SetContent EDXparms,true

' msgbox v.GetContent.string

'set Cname = App.GetProperties.Computername

TemplateDoc.SaveAs "C:\Users\ra053499\Downloads\ODAG.qvw"

TemplateDoc.Reload

end sub

Re: Passing Values from one QVW to another QVW using Macro

yasmeenk — Mon, 06 Nov 2017 13:38:25 GMT

Thanks for your efforts. But still it showing as Object required

Re: Passing Values from one QVW to another QVW using Macro

m_woolf — Mon, 06 Nov 2017 14:09:17 GMT

Did you add the EDXparms variable to your ODAQ Qlikview qvw?

Re: Passing Values from one QVW to another QVW using Macro

yasmeenk — Fri, 17 Nov 2017 05:37:48 GMT

Hi,

Have you tried this ODAG concept on QlikView Server?