I want to select rows in a table based on checking a SQL table value against a QlikView variable

[Anonymous]

I want to select rows in a table based on checking a SQL table value against a QlikView variable.

Something like:

PRESENT_PERIOD:

LOAD *;

SQL SELECT

    CURRENT_FISCAL_YEAR,

FROM PRESENT_PERIOD;

LET vCURRENT_FISCAL_YEAR = '=CURRENT_FISCAL_YEAR';

BUDGET:

LOAD 

        BudgetAmount

FROM

[local_data\Who gets what report.xlsx]

(ooxml, embedded labels, table is Budget_rows)

where FY=$(vCURRENT_FISCAL_YEAR);

This doesn't work.

error excerpt

where FY==CURRENT_FISCAL_YEAR

2018-07-13 15:52:14          21 fields found: ACCOUNTING_PERIOD_GLD, <snip>

2018-07-13 15:52:14      294,669 lines fetched

2018-07-13 15:52:14      Error: Unexpected token: '==', expected nothing

Any suggestions?

[vishsaggi · Accepted solution]

may be try this?

PRESENT_PERIOD:

LOAD *;

SQL SELECT

    CURRENT_FISCAL_YEAR,

FROM PRESENT_PERIOD;

LET vCURRENT_FISCAL_YEAR = Peek('CURRENT_FISCAL_YEAR',-1);

BUDGET:

LOAD

        BudgetAmount

FROM

[local_data\Who gets what report.xlsx]

(ooxml, embedded labels, table is Budget_rows)

where FY= '$(vCURRENT_FISCAL_YEAR)';