Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Macro parse failed

Hi

My Macro does´t work using QV Server. I get the message

Macro parse failed. Functionality was lost

ErrorSmiley Surprisedbject Required ValorCeldaDimension(..)

I pass this arguments:

set myvar = ValorCeldaDimensionPivot("CH46", "Indirectos", 2, 9)

and my funcction is: (to obtain the value of a cell in a pivot table where the text of the row =texto)

Function ValorCeldaDimensionPivot(objeto, texto, dimens, col)
set obj = ActiveDocument.GetSheetObject(objeto)
dim fila
fila = 0
for RowIter = 0 to obj.GetRowCount-1
set cell = obj.GetCell(RowIter,dimens)
if cell.Text = texto then
ValorCeldaDimensionPivot = obj.GetCell(fila, col)
exit Function
End if
fila = fila + 1
next
End Function

Anybody can help me?

1 Solution

Accepted Solutions
Not applicable

Macro parse failed

solved installing QV9 SR2

2 Replies
Not applicable

Macro parse failed

solved installing QV9 SR2

subin6600
Contributor III

Macro parse failed

I have got another work around which could help you solve the problem

1. Open your QVW file via Internet Explorer

2. Type Ctrl + Shift + M

3. Choose the option "Give System Access to Module Script" and click "OK".

untitled.JPG

BR,

Subin

Community Browser