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

Anonymous — Fri, 13 Jul 2018 20:00:08 GMT

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?

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

vishsaggi — Fri, 13 Jul 2018 20:06:27 GMT

may be try this?