topic Re: Qlikview Expression in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/479585#M179190 <HTML><HEAD></HEAD><BODY><P>For example use this in a text box:</P><P></P><P>=Sum({&lt;date = {"&gt;=$(=Date(MonthStart(Max(date))))&lt;=$(=Date(Max(date)))"}&gt;} sales)</P><P></P><P>Assuming date and sales are your field names, date dimension is a correctly interpreted date in standard date format.</P></BODY></HTML> Mon, 04 Nov 2013 23:03:38 GMT swuehl 2013-11-04T23:03:38Z Qlikview Expression https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/479584#M179189 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>wanted to ask how i can achieve the following task:</P><P></P><P>If I have a dimension date and I make a selection on any date, I expect that it should show me the cumulative sales from monthstart till the selected date. How I can achieve it?</P><P></P><P>My suggestion would be to use Set Analysis, or i am wrong?</P><P></P><P>Thanks,</P><P>Patric</P></BODY></HTML> Mon, 04 Nov 2013 22:44:12 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/479584#M179189 2013-11-04T22:44:12Z Re: Qlikview Expression https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/479585#M179190 <HTML><HEAD></HEAD><BODY><P>For example use this in a text box:</P><P></P><P>=Sum({&lt;date = {"&gt;=$(=Date(MonthStart(Max(date))))&lt;=$(=Date(Max(date)))"}&gt;} sales)</P><P></P><P>Assuming date and sales are your field names, date dimension is a correctly interpreted date in standard date format.</P></BODY></HTML> Mon, 04 Nov 2013 23:03:38 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/479585#M179190 swuehl 2013-11-04T23:03:38Z