topic What is wrong with my sentence? in QlikView https://community.qlik.com/t5/QlikView/What-is-wrong-with-my-sentence/m-p/335605#M123751 <HTML><HEAD></HEAD><BODY><P>=sum(If(Date(%DataID) &gt;= (date(min({&lt;Mes={"=max(Mes)"},Semana=&gt;}%DataID))) , VLR_VENDA_BRUTA ))</P><P></P><P>This part works quite well when I ask for it to return me a date: (date(min({&lt;Mes={"=max(Mes)"},Semana=&gt;}%DataID)))</P><P></P><P>Still when I fit it inside the sentence, it doesn't work! And the sentence seems to work fine because if I paste some other date there, it returns me a SUM!</P><P></P><P>Can anyone help me on that?</P><P></P><P>Cheers! </P></BODY></HTML> Thu, 02 Aug 2012 21:15:32 GMT 2012-08-02T21:15:32Z What is wrong with my sentence? https://community.qlik.com/t5/QlikView/What-is-wrong-with-my-sentence/m-p/335605#M123751 <HTML><HEAD></HEAD><BODY><P>=sum(If(Date(%DataID) &gt;= (date(min({&lt;Mes={"=max(Mes)"},Semana=&gt;}%DataID))) , VLR_VENDA_BRUTA ))</P><P></P><P>This part works quite well when I ask for it to return me a date: (date(min({&lt;Mes={"=max(Mes)"},Semana=&gt;}%DataID)))</P><P></P><P>Still when I fit it inside the sentence, it doesn't work! And the sentence seems to work fine because if I paste some other date there, it returns me a SUM!</P><P></P><P>Can anyone help me on that?</P><P></P><P>Cheers! </P></BODY></HTML> Thu, 02 Aug 2012 21:15:32 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-my-sentence/m-p/335605#M123751 2012-08-02T21:15:32Z Re: What is wrong with my sentence? https://community.qlik.com/t5/QlikView/What-is-wrong-with-my-sentence/m-p/335606#M123752 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva; color: #000000;">Try changing the sequence, like this: </SPAN></P><P><SPAN style="font-family: verdana, geneva; color: #000000;">=</SPAN><SPAN style="color: #000000; font-family: verdana, geneva;">i</SPAN><SPAN style="font-size: 12px; background-color: #eef4f9;">f(Date(%DataID) &gt;= (date(min({&lt;Mes={"=max(Mes)"},Semana=&gt;}%DataID))) , sum(VLR_VENDA_BRUTA)</SPAN></P><P></P><P>Cheers,</P><P>Henco</P><P><SPAN style="color: #000000; font-size: 12px; background-color: #eef4f9; font-family: verdana, geneva;"><BR /></SPAN></P></BODY></HTML> Fri, 03 Aug 2012 20:29:36 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-my-sentence/m-p/335606#M123752 Anonymous 2012-08-03T20:29:36Z