topic Macro Help - Set a Cell Value with Variable in QlikView

Macro Help - Set a Cell Value with Variable

wonkymeister — Tue, 16 Dec 2014 11:35:41 GMT

Hi,

i need to set a cell in a straight table with a value from a variable.

but my code isn't setting the cell with the value from the variable, instead its deleting the value from the variable. i think its getting the cell value (null) and setting the variable to it (null)

rather than doing what i want which is to get the value from the variable and setting it to the cell!

Sub GetTotal

set ch = ActiveDocument.GetSheetObject("CH01").GetCell(1,5) 'empty cell to populate

set vVar = ActiveDocument.Variables("vMyVariable") 'my variable that stores the value

vVar.SetContent ch.text, false

End Sub

Help!

Cheers.

Re: Macro Help - Set a Cell Value with Variable

Gysbert_Wassenaar — Tue, 16 Dec 2014 12:26:07 GMT

Qlikview is not a spreadsheet application like MS-Excel. It is not possible to set the value of a single cell. The values in the cells are calculated based on the dimensions and expressions of the chart (and the selections made by the user).

Re: Macro Help - Set a Cell Value with Variable

wonkymeister — Tue, 16 Dec 2014 12:49:49 GMT

the API provides a method called SetInputFieldCell which only works with a straight table box:

set obj = ActiveDocument.GetSheetObject("CH68")
obj.SetInputFieldCell 0,3,"999" 'set value in 2nd row, 2nd column to 999

Why wouldn't this work?

Re: Macro Help - Set a Cell Value with Variable

wonkymeister — Wed, 17 Dec 2014 08:24:43 GMT

Thanks Gysbert - i get it now.