Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your pivot relatively static you could set small buttons in each column which export this single column.
Marcus
OK, thanks!
Have a nice Holidays Season and New Year!
Regards,
Vladimir
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
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
The topic is similar - perhaps it is helpful.
http://community.qlik.com/thread/73166?start=0&tstart=0
- Marcus
Expressions are not selectable. However, in a pivot table, you can make the expression into a dimension. This is how it works:
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.
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