Why doesnt this resident load work???

Thu, 07 Mar 2013 16:38:08 GMT

main:
LOAD Meter_Reading_Date,
if(Meter_Reading_Date>='01/04/2012' and Meter_Reading_Date<='31/03/2013','12/13',
if(Meter_Reading_Date>='01/04/2011' and Meter_Reading_Date<='31/03/2012','11/12',
if(Meter_Reading_Date>='01/04/2010' and Meter_Reading_Date<='31/03/2011','10/11',
if(Meter_Reading_Date>='01/04/2009' and Meter_Reading_Date<='31/03/2010','09/10',
if(Meter_Reading_Date>='01/04/2008' and Meter_Reading_Date<='31/03/2009','08/09'))))) as Read_Year,
     Equipment_Number,
     Device,
     Places_Before_Decimal_Point_In_Meter_Reading as Reading
FROM

(qvd)
where Exists(Equipment_Number)
;

res:
load Read_Year as [08/09],
if(FirstSortedValue(Reading,-Meter_Reading_Date)-FirstSortedValue(Reading,Meter_Reading_Date)<0,
FirstSortedValue(Reading,-Meter_Reading_Date)-FirstSortedValue(Reading,Meter_Reading_Date)+9999,
FirstSortedValue(Reading,-Meter_Reading_Date)-FirstSortedValue(Reading,Meter_Reading_Date)) as oheightonine
resident main

where [08/09]='08/09'
;

Re: Why doesnt this resident load work???

jagan — Thu, 07 Mar 2013 16:46:17 GMT

HI,

In the resident load script the where condition is the problem

Instead of this

mainwhere [08/09]='08/09'

use this

Read_Year ='08/09'

Regards,

Jagan.

topic Re: Why doesnt this resident load work??? in QlikView

Why doesnt this resident load work???

Re: Why doesnt this resident load work???