topic How to use tables Resident from Macros in QlikView

How to use tables Resident from Macros

manudenegri — Thu, 14 Jun 2018 15:27:32 GMT

Hi I would like to use datas from a resident Table using macros

I have:

GRAPH:

LOAD * INLINE [

nombre, edad

CH22, 55

CH23, 55

CH24, 56

CH25, 57

CH26, 58

CH27, 59

];

And I want to acces to any cell of this table like if I was using "PEEK" function ... this is a very small example I need,

Thx a lot

settu_periasamy — Thu, 14 Jun 2018 18:07:39 GMT

Hi,

Can you tell what to do you want to achieve?

manudenegri — Fri, 15 Jun 2018 06:16:44 GMT

Hi Settu

I need to read from Macro Module a resident Table loaded in Script

Y would like to have in a vba variabel the value of a cell of the table i.e value 56 from field "edad"

something like:

Dim Dato as Integer

Dato = '..... I don't know this sentence .....'

msgbox Dato

This is what I need ... later I'll aply this concept to another thing

Thx a lot