Adding previous statement causing other statements to fail

Fri, 09 Nov 2012 08:37:42 GMT

Hi, I have created the load script below but I can't figure out why I get the results that I do. With the "previous" statement commented out as it is the statements that follow it work fine and return values but as soon as I add the "previous" statement I get the expected results from the previous statement (= yesterday's value) but the 2 following calculation statements now return no values. Can anyone explain why?

[Daily Stats]:
LOAD Date, 
           Month(Date) as OrderMonth,
     Year(Date) as OrderYear,
     Time, 
     Start as DayOpen, 
     High as DayHigh, 
     Low as DayLow, 
     End as DayClose, 
     Volume as DayVolume, 
     [Daily 20 EMA]as [EMA Daily 20],
     //Previous([Daily 20 EMA]) as [EMA 20 Yesterday],
     Round(([Daily 20 EMA] - lookup('BuySL','Date',Date,'Trade Results'))*100,10) as [EMA Daily 20 v SL],
     If([Daily 20 EMA]>lookup('Buy Open','Date',Date,'Trade Results'),'Above Buy',If([Daily 20 EMA]<lookup('Sell Open','Date',Date,'Trade Results'),'Below Sell','Asia Range')) as [EMA Daily Position],
     DailyStoch%K
FROM
[EURJPY 2yr Daily.xlsx]
(ooxml, embedded labels);

topic Adding previous statement causing other statements to fail in QlikView

Adding previous statement causing other statements to fail