topic Re: Querying a value within a data load in QlikView

Querying a value within a data load

Wed, 25 Nov 2020 16:16:04 GMT

I am looking for some Qlikview help.

I have loaded a QVD into memory (eg called DATAX), one particular column in here has a list of XLS file names.

Separately I have a particular file name, that I have stored (as it is derived differently by checking folder contents) eg $(vLatestXLS)

I want to check within the QVD data loaded memory (DATAX), if this $(vLatestXLS) already exists in there?

What command do I use to search the Datax while reloading the document? I trying to use peek. Would this be the correct one?

Thanks

Clever_Anjos — Wed, 04 Oct 2017 16:44:05 GMT

Lookup() function maybe can help you

oscar_ortiz — Wed, 04 Oct 2017 17:14:05 GMT

Are you simply trying to do something like this?

TempData:

Load

YourColumn,

YourColumn1,

YourColumn2

Resident

DATAX

Where

YourColumn = $(vLatestXLS)

;

Good Luck

Oscar