Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_schmidt
Contributor

Data editor & for each

Hi,

i think i have a pretty simple question.

I would like to set an array in my data editor script with a few values.

I would like then to export a QVD file as often as i have values in that array.

I did the following so far:

SET list = ValueList('1', '2');

FOR EACH var IN list

    STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

NEXT VAR;

This is working, but it only exports one file with the name: '1,2.qvd'.

Can somebody tell me how to correct this?

As well can somebody tell me if there is a good script documentation for the data editor?

The official online qlik help doesnt cover all the aspects of that script language i think.

Thanks a lot.

1 Solution

Accepted Solutions

Re: Data editor & for each

HI in that case you can create a inline table and use that in script like below

Inline:

Load * inline [

Field

1

2

];

Let vCount = noofrows('Inline');

For i =0 to $(vCount) -1

     Let var = peek('Field',$(i),'Inline');

     STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

Next

Regards,

Kaushik Solanki

13 Replies

Re: Data editor & for each

May be this

SET list = 1, 2;

FOR EACH var IN list

    STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

NEXT VAR;

Re: Data editor & for each

Hi,

Try this.

FOR EACH var IN '1','2'

  STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

NEXT var;

Regards,

Kaushik Solanki

j_schmidt
Contributor

Re: Data editor & for each

hi,

this might work but i need to put it in a variable because i would like to set

init varaibles at the beginning of my script, which is a bit longer than my example here.

Cheers

j_schmidt
Contributor

Re: Data editor & for each

I tried this too but its not working :/

Re: Data editor & for each

stalwar1

I dont think this will work.

It wont take each value.

Regards,

Kaushik Solanki

Re: Data editor & for each

Did you try what I proposed?

j_schmidt
Contributor

Re: Data editor & for each

Yes i did, not working, sorry :/

Re: Data editor & for each

I think dollar sign expansion is needed.... this works

SET list = 1, 2;

FOR EACH var IN $(list)

    TRACE $(var);

NEXT var;

Re: Data editor & for each

Try this

SET list = 1, 2;

FOR EACH var IN $(list)

    STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

NEXT VAR;

Community Browser