topic Need help with a Macro in QlikView

Need help with a Macro

Thu, 19 Apr 2012 20:23:43 GMT

Dear All,

Please help me understand the meaning of this macro statements:

Sub(move)

set ListBox = ActiveDocument.GetSheetObject("CH15")

Set cell = listBox.GetCell(2,9)

ActiveDocument.Variables("tutan").SetContent cell.text, true

CH15 object is a straight table.

Set cell = listBox.GetCell(3,9)

ActiveDocument.Variables("manka").SetContent cell.text, true

Thanks,

Tutan

Re: Need help with a Macro

Thu, 19 Apr 2012 20:27:33 GMT

it's assigning the value at row 2 column 9 from your table "CH15" to the variable tutan.

Need help with a Macro

Thu, 19 Apr 2012 21:31:47 GMT

Instead of using a Macro, how can I pass values to the variable tutan from row 2 column 9 from the table CH15? Is there a way I can code this in the load script? So that , I dont need a macro to run when a button is pressed. Instead, this the variable tutan is automatically loaded once we hit reload.

Thanks,

Tutan

Need help with a Macro

Thu, 19 Apr 2012 21:34:05 GMT

I'd need to know what is being displayed in that cell. could you upload an example of your QVW?