Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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