topic Re: String Array in Edit Script in QlikView

String Array in Edit Script

Tue, 19 Feb 2013 12:44:14 GMT

Hi ,

I want to create a string array in Edit Script of the Qlikview document and loop through the array.

I tried using

Let Arr[2] = {A,b};

but it is throwing a syntax error. Can anyone help me on this?

Thanks in Advance.

Regards,

M.Santosh Kumari

Re: String Array in Edit Script

Tue, 19 Feb 2013 13:10:46 GMT

You can concatenate their words and by a separate identifier.

Ex.:

LET array = "abcd, 123, xyz";

To scroll through your array, you can use functions character subfield:

TEST:

LOAD

Subfield ('$ (array)', ',', Rowno ()) AS STR

AutoGenerate (3);

Where ',' as the separator and definitions of your array and Rowno() refers to the position of your text to go.

Re: String Array in Edit Script

erichshiino — Tue, 19 Feb 2013 13:24:05 GMT

Hi,

I suggest you create your array in a table then, you can loop the rows:

Table:

LOAD * INLINE [

];

let x = NoOfRows('Table'); // Get number of itens in "Array"

//Loop Table Rows

For i = 0 to x-1

let content = peek('F1',i,'Table') ;//Get the n-th item

Trace $(content); //It can be used! (in this case, it is just printed in the script log)

drop table Table; // optional

Hope it helps,

Regards,

Erich

Re: String Array in Edit Script

Tue, 19 Feb 2013 13:24:24 GMT

Hi ,

Actually i am using an EDX trigger, and i am passing a string array from the API to the Qlikview EditScript where i want to use the string array.

For Example i have the string array as below :

Arr[0] = 1;

Arr[1]=123;

and i pass the array as say "Arr".

I want to access the above Arr in my edit script. When i just use Arr, i am able to acess the first value i.e 1, but i am not sure of how to use the 123 value in the list.

Regards,

Santosh Kumari

Re: String Array in Edit Script

erichshiino — Tue, 19 Feb 2013 14:36:00 GMT

Hi,

Instead of an array, can you concatenate the values in a single value and use Eduardo's approach?

Regards,

Erich

Re: String Array in Edit Script

arieidel — Tue, 11 Oct 2016 16:54:15 GMT

Hello Erich,

Just to tell you that I was also looking for a "String Array in Edit Script" and your suggestion was exactly what I needed.

Thanks.
Ariel