Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)';
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)';