topic Re: Needed help QV macro in QlikView

Needed help QV macro

Mon, 17 Sep 2012 09:09:47 GMT

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

kaushiknsolanki — Mon, 17 Sep 2012 09:13:38 GMT

Hi,

Following is the code for accessing Varibale in Macro

set v = ActiveDocument.GetVariable("Variable1")

abc = v.GetContent.String

Cheers

Regards,

Kaushik Solanki

Mon, 17 Sep 2012 11:35:10 GMT

Hello Kaushik,

Thanks a lot....

Regards

Chriss