topic How can i use array in editscrit? in QlikView

How can i use array in editscrit?

jagannalla — Wed, 24 Aug 2011 10:57:03 GMT

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;

How can i provide above functionality in editscript?

its_anandrjs — Wed, 24 Aug 2011 11:00:06 GMT

Hi,

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

Regards

Anand

jagannalla — Wed, 24 Aug 2011 11:15:28 GMT

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

fosuzuki — Wed, 31 Aug 2011 16:55:52 GMT

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

Regards,

Fernando

jagannalla — Tue, 06 Sep 2011 13:44:07 GMT

Thanks Fernando..It's working