Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Recently moved over from Qlikview to QlikSense Cloud and running across a weird issue when setting a variable using a date. When I run the script below, it does not filter out the data to pull records prior to 12/31/23. When I remove the variable and use a where clause with '12/31/23', the records are pulled properly. Am I missing something simple?
-----------------------------------------------------------------------------
Let vHistoricalDate = '12/31/23';
PAYROLLBATCH_EMPLOYEE_HISTORICAL:
LOAD
*,
'Historical Load' as Load_Source
Resident Pre_PAYROLLBATCH_EMPLOYEE_Historical
Where BatchInvoiceDate <= $(vHistoricalDate);
---------------------------------------------------------------------------------
Maybe try like this, with single ' :
Where BatchInvoiceDate <= '$(vHistoricalDate)';
Let me know if it works ?
Regards
Antoine
Maybe try like this, with single ' :
Where BatchInvoiceDate <= '$(vHistoricalDate)';
Let me know if it works ?
Regards
Antoine
That did the trick, thank you Antoine!