topic Setting variable in the load from a table in QlikView

Setting variable in the load from a table

Wed, 15 Jun 2016 20:33:31 GMT

Hi,

So I have a simple table that I use to determine whether or not I want to load data from certain regions, its called Active regions.

The structure is something like this

Region	Operational
North	1
South	0
East	0
West	1

I want to create a variable called vLOAD if the region is North and Operational is 1. I then want to use that vLOAD variable to say, if vLOAD =1 then load another table, if not then move down the script.

Is this type of thing possible?

Thanks

Stuart

Re: Setting variable in the load from a table

sunny_talwar — Wed, 15 Jun 2016 20:37:53 GMT

May be like this:

Table:

LOAD Concat(Operational, ', ', Key) as List;

LOAD RecNo() as Key,

Region,

Operational

FROM

[https://community.qlik.com/thread/221010]

(html, codepage is 1252, embedded labels, table is @1);

LET vNorth = SubField(Peek('List'), ', ', 1);

LET vSouth = SubField(Peek('List'), ', ', 2);

LET vEast = SubField(Peek('List'), ', ', 3);

LET vWest = SubField(Peek('List'), ', ', 4);

Re: Setting variable in the load from a table

swuehl — Wed, 15 Jun 2016 21:14:17 GMT

You can also access directly your original table:

Table:

LOAD

Region,

Operational

FROM

[https://community.qlik.com/thread/221010]

(html, codepage is 1252, embedded labels, table is @1);

Let vLOAD = Lookup('Operational','Region','North','Table');

If vLOAD = 1 THEN .....

Re: Setting variable in the load from a table

Thu, 16 Jun 2016 12:25:08 GMT

Thank you. I know these thangs are failrly simple but you are a guru !