How can i use array in editscrit?

[jagannalla]

Hi,

I've a qvd file with some  fields(A,B,C,D,E etc) now i'll store this fields in one variable vFields=A,B,C.

In edit script i will return like this.

Table1:

Load $(vFields) from table1.qvd;

-  I want max and min of the fields available in variable.

for eg:

Load

max(A) as MaxA,

min(A) as MinA

Resident Table1;

- But in the place of A, i want provide with Array functionality (i.e Arr)

Arr[]={A,B,C}

For Eg the structure work like this :

for i =0 to 3

Load

Max(Arr) as MaxArr,

Min(Arr) as MinArr

Resident Table1;

next

How can i provide above functionality in editscript?

[its_anandrjs]

Hi,

I think you need to use the autogenerate function in qlikview.

Regards

Anand

[jagannalla]

how can i add fields dynamically and find the max & min?

[fosuzuki]

Try this sample:

let f = 'A, B, C';

let n = SubStringCount('$(f)', ',');

for i = 1 to $(n) + 1

  let x = subfield('$(f)', ',', $(i));

   //insert here your load statement

next

Regards,

Fernando

[jagannalla]

Thanks Fernando..It's working