topic Re: set analysis with date function in QlikView https://community.qlik.com/t5/QlikView/set-analysis-with-date-function/m-p/63788#M608873 <HTML><HEAD></HEAD><BODY><P>Replace the outer single quotes with double quotes and also add an equal sign</P><P></P><P><STRONG>Sum({&lt;DATE_PRODUCTION={<SPAN style="color: #ff0000;">"=</SPAN>Date(Date#(DATE_PROD), 'DDMMYYYY') &lt;= $(=DATE_EXTRA)<SPAN style="color: #ff0000;">"</SPAN>}&gt;}PRODUCTION)</STRONG></P></BODY></HTML> Wed, 21 Feb 2018 12:47:27 GMT sunny_talwar 2018-02-21T12:47:27Z set analysis with date function https://community.qlik.com/t5/QlikView/set-analysis-with-date-function/m-p/63787#M608872 <HTML><HEAD></HEAD><BODY><P>I have</P><P>SUM({&lt;DATE_PRODUCTION={'DATE(date#(DATE_PROD),'<SPAN style="color: #ff0000;">DDMMYYYY') &lt;= $(=DATE_EXTRA)'}&gt;}PRODUCTION)</SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">in this part the experssion with red line (error)</SPAN></P></BODY></HTML> Wed, 21 Feb 2018 12:41:52 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-date-function/m-p/63787#M608872 souadouert 2018-02-21T12:41:52Z Re: set analysis with date function https://community.qlik.com/t5/QlikView/set-analysis-with-date-function/m-p/63788#M608873 <HTML><HEAD></HEAD><BODY><P>Replace the outer single quotes with double quotes and also add an equal sign</P><P></P><P><STRONG>Sum({&lt;DATE_PRODUCTION={<SPAN style="color: #ff0000;">"=</SPAN>Date(Date#(DATE_PROD), 'DDMMYYYY') &lt;= $(=DATE_EXTRA)<SPAN style="color: #ff0000;">"</SPAN>}&gt;}PRODUCTION)</STRONG></P></BODY></HTML> Wed, 21 Feb 2018 12:47:27 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-date-function/m-p/63788#M608873 sunny_talwar 2018-02-21T12:47:27Z