topic why doesnt this work??? in QlikView https://community.qlik.com/t5/QlikView/why-doesnt-this-work/m-p/374331#M1175652 <HTML><HEAD></HEAD><BODY><P>Maybe remove the single quotes around the numbers.</P></BODY></HTML> Wed, 30 May 2012 10:41:06 GMT 2012-05-30T10:41:06Z why doesnt this work??? https://community.qlik.com/t5/QlikView/why-doesnt-this-work/m-p/374330#M1175651 <HTML><HEAD></HEAD><BODY><P>if(FirstSortedValue(Places_Before_Decimal_Point_In_Meter_Reading,Meter_Reading_Date)&lt;='425' </P><P>&nbsp;&nbsp;&nbsp;&nbsp; or FirstSortedValue(Places_Before_Decimal_Point_In_Meter_Reading,Meter_Reading_Date)&gt;='365','In Period','Out of period') as range,</P><P></P><P></P><P>trying to get earliest value in 365-425 date range, it says 'invalid expression' despite the synttax checker not flagging it up.</P></BODY></HTML> Wed, 30 May 2012 10:38:59 GMT https://community.qlik.com/t5/QlikView/why-doesnt-this-work/m-p/374330#M1175651 2012-05-30T10:38:59Z why doesnt this work??? https://community.qlik.com/t5/QlikView/why-doesnt-this-work/m-p/374331#M1175652 <HTML><HEAD></HEAD><BODY><P>Maybe remove the single quotes around the numbers.</P></BODY></HTML> Wed, 30 May 2012 10:41:06 GMT https://community.qlik.com/t5/QlikView/why-doesnt-this-work/m-p/374331#M1175652 2012-05-30T10:41:06Z