Syntax Question In A Load Statement

Anonymous — Thu, 25 Jul 2013 21:01:19 GMT

Hello my friends. I cannot figure out why the code below is not working. I am simply trying to filter my results by a date variable.

LOAD   LTRIM(RTRIM(PHPCTL)) AS PickticketCtrlNum, 
       LTRIM(RTRIM(PHPGDT)) AS PktGenerationDate, 
       LTRIM(RTRIM(PHPRWV)) AS PrintWave, 
       LTRIM(RTRIM(PHMIS1)) AS MiscIns5Byte1, 
       LTRIM(RTRIM(PHMIS4)) AS MATCH, 
       LTRIM(RTRIM(PHSC3))  AS SpecialInsCode3, 
       LTRIM(RTRIM(PHSOTO)) AS Soldto, 
       LTRIM(RTRIM(PHSHTO)) AS Shipto, 
       LTRIM(RTRIM(PHSONM)) AS SoldtoName, 
       STARTSHIPDATE,
       STOPSHIPDATE, 
       SHIPDATE,
       LTRIM(RTRIM(PHSVIA)) AS PlannedShipVia, 
       LTRIM(RTRIM(PHSVID)) AS ShipViaDesc, 
       LTRIM(RTRIM(PHPHLF)) AS PackAndHoldFlag, 
       LTRIM(RTRIM(PHCUPO)) AS CustPONum, 
       LTRIM(RTRIM(PHTCT))  AS TotNbrOfCartons, 
       LTRIM(RTRIM(PHTUTS)) AS TotNbrOfUnits,
       LTRIM(RTRIM(PHSHDT)) AS ORIGINALSHIPDATE,
       LTRIM(RTRIM(LXLDNO)) AS LoadNumber, 
       LTRIM(RTRIM(LXSHNO)) AS ShipmntNumber,
       LTRIM(RTRIM(PDPAKU)) AS UnitsPacked, 
       LTRIM(RTRIM(PDPRC))  AS Price, 
       LTRIM(RTRIM(PDSEA))  AS SEASON, 
       LTRIM(RTRIM(PDBCHN)) AS LotNum, 
       LTRIM(RTRIM(PDSYR))  AS SeasonYear, 
       LTRIM(RTRIM(PDSTYL)) AS Style,
       PDBCHN*PDPAKU AS Ext_Retail,
       PDBCHN*PDPAKU*0.425 AS Ext_Cost
       WHERE SHIPDATE >= $(zconvDate)
;

Re: Syntax Question In A Load Statement

MayilVahanan — Thu, 25 Jul 2013 22:18:20 GMT

Try like this

Did u declare zconvDate in Set or let?

if you declare in let, then WHERE SHIPDATE >= '$(zconvDate)';

And also, check the shipdate and zconvDate is in same date format?

Additional information:

Instead of ltrim(rtrim()) option use trim() function

topic Re: Syntax Question In A Load Statement in QlikView

Syntax Question In A Load Statement

Re: Syntax Question In A Load Statement