topic Dates minstring/maxstring and sum if - Help in QlikView https://community.qlik.com/t5/QlikView/Dates-minstring-maxstring-and-sum-if-Help/m-p/350280#M129803 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been playing around with an existing project trying to replace pure expressions (for each year) to 1 single expression ever the Year dimension.</P><P></P><P>I have previously used Varbles for yearstart/yearend; I have now changed this in the expresion to maxstring(Date) and minstring(Date) which should return the 31/12/xxxx and 1/1/xxxx respectivly.</P><P></P><P>I am applying this within a sum(If statement and it seems to error out; does anyone have any idea where I am going wrong.</P><P></P><P></P><P>Many thanks</P></BODY></HTML> Tue, 13 Mar 2012 14:12:08 GMT 2012-03-13T14:12:08Z Dates minstring/maxstring and sum if - Help https://community.qlik.com/t5/QlikView/Dates-minstring-maxstring-and-sum-if-Help/m-p/350280#M129803 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been playing around with an existing project trying to replace pure expressions (for each year) to 1 single expression ever the Year dimension.</P><P></P><P>I have previously used Varbles for yearstart/yearend; I have now changed this in the expresion to maxstring(Date) and minstring(Date) which should return the 31/12/xxxx and 1/1/xxxx respectivly.</P><P></P><P>I am applying this within a sum(If statement and it seems to error out; does anyone have any idea where I am going wrong.</P><P></P><P></P><P>Many thanks</P></BODY></HTML> Tue, 13 Mar 2012 14:12:08 GMT https://community.qlik.com/t5/QlikView/Dates-minstring-maxstring-and-sum-if-Help/m-p/350280#M129803 2012-03-13T14:12:08Z