topic Transform expression to set analysis in QlikView https://community.qlik.com/t5/QlikView/Transform-expression-to-set-analysis/m-p/463464#M484616 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>how can I transform this expression to set analysis?</P><P>=sum( if(Date= date(DayStart( MonthEnd(Date))),VAL))</P><P></P><P>thx,</P><P>Yacine</P></BODY></HTML> Wed, 15 May 2013 17:14:00 GMT 2013-05-15T17:14:00Z Transform expression to set analysis https://community.qlik.com/t5/QlikView/Transform-expression-to-set-analysis/m-p/463464#M484616 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>how can I transform this expression to set analysis?</P><P>=sum( if(Date= date(DayStart( MonthEnd(Date))),VAL))</P><P></P><P>thx,</P><P>Yacine</P></BODY></HTML> Wed, 15 May 2013 17:14:00 GMT https://community.qlik.com/t5/QlikView/Transform-expression-to-set-analysis/m-p/463464#M484616 2013-05-15T17:14:00Z Re: Transform expression to set analysis https://community.qlik.com/t5/QlikView/Transform-expression-to-set-analysis/m-p/463465#M484617 <HTML><HEAD></HEAD><BODY><P>Try with this</P><P>=Sum({&lt;Date={"=Date=Date(Floor(MonthEnd(Date)))"}&gt;} VAL)</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 15 May 2013 17:17:48 GMT https://community.qlik.com/t5/QlikView/Transform-expression-to-set-analysis/m-p/463465#M484617 CELAMBARASAN 2013-05-15T17:17:48Z