Getting random Cell values

[vlad_komarov]

Hello,

I am looking for the way to retrieve a cell data from Straight or Pivot tables. Basically, I need to have an option to click on the table (right click - to avoid selections, for example) and get the cell's value along with Row and Column number.

Copy the cell value to clipboard will not work in my case since I need to know cell's coordinates.

I need to report that specic cell (Column # = A and Row # = B) has a value = C.

Is it possible?

Looking forward to your suggestions.

Best regards,

Vladimir

[marcus_sommer]

If your pivot relatively static you could set small buttons in each column which export this single column.

Marcus

[vlad_komarov]

OK, thanks!

Have a nice Holidays Season and New Year!

Regards,

Vladimir

[vlad_komarov]

My table(s) are not very "static" - I am giving my client an option to show/hide specific columns, but your suggestions looks like the only solution so far.

Thanks!

Regards,

Vladimir

[#5]

If I would like to activate that cell to make that the Chart Navigate forward more associative information, what should i do?

Sub GetCellValue

    RowNo=6

    ColNo=2

    set obj = ActiveDocument.GetSheetObject( "CH01" )

    set cell = obj.GetCell(RowNo,ColNo)

    msgbox(cell.Text)

     //Selects the cell to navigate forward in current data chart

     cell.select(): //how to select that cell????

end sub

[marcus_sommer]

The topic is similar - perhaps it is helpful.

http://community.qlik.com/thread/73166?start=0&tstart=0

- Marcus

[#7]

Expressions are not selectable. However, in a pivot table, you can make the expression into a dimension. This is how it works:

• The existing dimensions remain the same.
• Create a new field (e.g., expression_field) with the values 1 to the number of expressions needed.
• Use a pick function for the expression that will choose the actual expression based on the expression_field dimensions (.e.g., pick(expression_field, expression1, expression2, expression3).
• There should only be one expression.

The "expressions" are now selectable.

In practice, the pick function becomes slow with many expressions. Depending on the complexity of the expression, this method maybe unusable before you reach 200 expressions.

[#8]

Gysbert.

How could i use macro a pivot table.

eg.

Expression = GetCellValue(11,1)

i sent as parameters the row and column and the function returns me the value of the cell.

1) How to define the function

2) As i invoke the function