Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Needed help QV macro

Hello Friends,

I would like to read the variable and assigned value in the QV macro.

For instance, In a pivot table and I have 35 rows, using NoOfRows() function I can store the value in a X variable.

But I would like to use the same variable in VB marco, when I try to print the variable it shows nothing.

Could you please anyone tell me how  do I read the variable in the Edit module.

Thanks and Regards

Chriss

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Following is the code for accessing Varibale in Macro

    set v = ActiveDocument.GetVariable("Variable1")

    abc = v.GetContent.String

     Cheers

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Hello Kaushik,

Thanks a lot....

Regards

Chriss