topic Set anaylsis variables in QlikView https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269769#M101181 <HTML><HEAD></HEAD><BODY><P> hei</P><P></P><P>use this one</P><P></P><P>sum({&lt;DateOfCall={"&gt;$(=daystart(today()-14))"}&gt;} IVR_Call_Count)</P></BODY></HTML> Mon, 24 Oct 2011 09:14:50 GMT lironbaram 2011-10-24T09:14:50Z Set anaylsis variables https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269768#M101180 <HTML><HEAD></HEAD><BODY><P>Guys, i am having trouble with some syntax on qlikview i hope you could help.</P><P></P><P>Below is an example of what i am trying to achieve.</P><P>sum({&lt;DateOfCall={'&gt;daystart(today()-14)'}&gt;} IVR_Call_Count)</P><P></P><P>Date of call is a field with date/time format</P><P>the day start wraps the today function in to the same format.</P><P>all functions work indepentently with correct results but i cant find the syntax to run it like the above.</P><P></P><P>regards</P><P></P><P>alan</P></BODY></HTML> Mon, 24 Oct 2011 09:04:08 GMT https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269768#M101180 2011-10-24T09:04:08Z Set anaylsis variables https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269769#M101181 <HTML><HEAD></HEAD><BODY><P> hei</P><P></P><P>use this one</P><P></P><P>sum({&lt;DateOfCall={"&gt;$(=daystart(today()-14))"}&gt;} IVR_Call_Count)</P></BODY></HTML> Mon, 24 Oct 2011 09:14:50 GMT https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269769#M101181 lironbaram 2011-10-24T09:14:50Z Set anaylsis variables https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269770#M101182 <HTML><HEAD></HEAD><BODY><P>perfect thanks i see exactly where i was incorrect. appreciate your support</P></BODY></HTML> Mon, 24 Oct 2011 09:18:15 GMT https://community.qlik.com/t5/QlikView/Set-anaylsis-variables/m-p/269770#M101182 2011-10-24T09:18:15Z