topic Re: Create a list from a table in QlikView

Create a list from a table

christophebrock1 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm trying to load a list of values into a variable, which I want to use next to loop through in my qliksense script.

I did this many times before, but it seems I lost my reference file and can't seem to find myself how I did it in the past.

This is my (non working) script:

------

Websites:

LOAD

WebsiteID,

Country

FROM [lib://Data/180820-website-datastructure.xlsx]

(ooxml, embedded labels, table is GAIDs);

Let vGAIDs = peek('WebsiteID',0,'Websites');

-------

It only seems to load the first field into the variable. Any idea what I'm doing wrong?

Kind regards,

Christophe

Re: Create a list from a table

trdandamudi — Wed, 22 Aug 2018 15:36:11 GMT

See if the below link helps:

How to assign multiple values to a single varia... | Qlik Community

Re: Create a list from a table

vamsee — Wed, 22 Aug 2018 15:40:45 GMT

Try this

Let LoopNumber=1;

For LoopNumber= 1 to NoofRows('Websites')

LET vCountry= Peek('WebsiteID', LoopNumber-1, 'Websites');

Script;

Next;

Re: Create a list from a table

rwunderlich — Thu, 23 Aug 2018 04:12:27 GMT

I'm understanding that you want a comma separated list of single quoted WebsiteID values to use in a For Each loop. Try:

// Build a string list in a single field, one row table

TempWebSiteListTable:

LOAD

chr(39) & Concat(WebsiteID, chr(39) & ',' & chr(39), WebsiteID) & chr(39)

as TempWebSiteList

Resident Websites

;

// Put the website list in a variable

LET vGAIDs = peek('TempWebSiteList');

// Delete the temp table

DROP TABLE TempWebSiteListTable;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

Re: Create a list from a table

twon23 — Thu, 26 Sep 2019 01:41:12 GMT

Great solution, thank you!