topic Re: Array to QVD in QlikView

Array to QVD

Mon, 26 Jan 2026 18:19:17 GMT

I have two array variables and aI need one qvd file wiht this two variable somethilng like this:

vLocal = "?Recife?Rio de Janeiro?Sao Paulo?Salvador"

vGerente="?Carlos Afonso?Thiago Jose?Antonio Carlos?Katia Maria"

And I need a qvd file like

Local Gerente

Recife Carlos Afonso

Rio de Janeiro Thiago Jose

Sao Paulo Antonio Carlos

Salvador Katia Maria

How can I do this?

rubenmarin — Thu, 05 Mar 2015 16:19:26 GMT

Hi Luiz Fernando, you can use an script like this:

SET vLocal = "?Recife?Rio de Janeiro?Sao Paulo?Salvador";

SET vGerente="?Carlos Afonso?Thiago Jose?Antonio Carlos?Katia Maria";

LET vNumValues=SubStringCount('$(vLocal)', '?');

For i=2 to vNumValues+2

data:

LOAD SubField('$(vLocal)', '?', $(i)) as Local,

SubField('$(vGerente)', '?', $(i)) as Gerente

AutoGenerate 1;

STORE data into data.qvd(qvd);

Thu, 05 Mar 2015 16:44:24 GMT

Hi Ruben

It works fine , thanks

rwunderlich — Thu, 05 Mar 2015 19:45:54 GMT

You don't need a FOR loop. If you use only two parameters to subfield(), QV will automatically generate mutiple rows.

data:

LOAD SubField('$(vLocal)', '?') as Local,

SubField('$(vGerente)', '?') as Gerente

AutoGenerate 1;

-Rob