topic Re: Creating a variable from a Load in QlikView

Creating a variable from a Load

zagzebski — Fri, 15 Nov 2013 16:22:45 GMT

I need take the Max Date of a table (Master Cube table below) and use that date in my where clause for another table.

I know my script is NOT right below. But how do I get the vGLDATE field from the Master Cube into the Where clause of my Current Budget table

Master Cube:

Load

max(GLDATE) as vGLDATE

Resident Production;

Current Budget:

Load *

Resident Budget

Where vGLDATE < BUDGET_DATE;

Thanks,

Steve

Aurelien_Martinez — Fri, 15 Nov 2013 16:26:55 GMT

Hi,

Try:

Master Cube:

Load

max(GLDATE) as vGLDATE

Resident Production;

LET vGLDATE = Peek('vGLDATE', 0, 'Master Cube')

Current Budget:

Load *

Resident Budget

Where $(vGLDATE) < BUDGET_DATE;

Best,

Aurélien

zagzebski — Fri, 15 Nov 2013 16:37:49 GMT

Thanks so much.

Just some clairification

LET vGLDATE = Peek('vGLDATE,0,"Master Cube")

What is the peek function doing? Is it saying look at the last vGLDATE and if you find nothing make it a 0 or therwise give me the date?

Thanks, Steve

Aurelien_Martinez — Fri, 15 Nov 2013 16:43:49 GMT

When you use Peek function like : Peek('vGLDATE,0,"Master Cube")

Peek returns the value of vGLDATE from the first record read into the input table labeled Master Cube.

Read "Inter Record Functions" in QlikView Help