topic Re: Store information on Variables in QlikView

Store information on Variables

GLicks_DG — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Is there any way to store information from a given table into a variable?

For instance, I need to use the count of a given dimension in future calculations. So I was trying something like this:

Table:

Load Dim1, Dim2 from [a given file];

LET vCount = count(Dim1) resident Table;

Thank sin advance!

marcus_malinow — Tue, 09 Jul 2019 14:54:14 GMT

Try this

Temp:

LOAD

count(Dim1) as Dim1Count

RESIDENT Table;

LET vCount = peek('Dim1Count',-1);

DROP TABLE Temp;

GLicks_DG — Tue, 09 Jul 2019 15:11:01 GMT

@marcus_malinow It worked perfectly. Thank you!

marcus_malinow — Tue, 09 Jul 2019 15:34:33 GMT

You're welcome, happy to help