Getting cell value from an expression or calculated dimension column

Tue, 29 Oct 2013 09:31:09 GMT

Hello,

Is there a way to get the value (into some string) from a cell in an expression column or from a calculated dimention?

Thanks!

Re: Getting cell value from an expression or calculated dimension column

Gysbert_Wassenaar — Tue, 29 Oct 2013 16:53:23 GMT

Depends on what you need. It's possible to use a macro to get a value from a cell if you know the row and column of the cell you're interested in:

Sub GetCellValue
    RowNo=6
    ColNo=2
    set obj = ActiveDocument.GetSheetObject( "CH01" )
    set cell = obj.GetCell(RowNo,ColNo)
    msgbox(cell.Text)
end sub

If that's not a workable solution you'll have to reuse the expression that calculated the value and possibly modify it so it calculates the value for the right dimension value(s).

topic Getting cell value from an expression or calculated dimension column in QlikView

Getting cell value from an expression or calculated dimension column

Re: Getting cell value from an expression or calculated dimension column