topic Expression Help in QlikView https://community.qlik.com/t5/QlikView/Expression-Help/m-p/321487#M118449 <HTML><HEAD></HEAD><BODY><P>Hi Dear Friends;</P><P></P><P>I need help by creating expression formula to calculate monthly based.</P><P></P><P>I want to calculate sales quantity. But I also want to calculate especially in a such way ;</P><P></P><P>When I select a date from calendar I want to see total calculate for "monthstart - selected date" period.</P><P></P><P>Forexample ; <STRONG>Today :</STRONG> 15.11.2011. So daily I want to show in the table "Monthly Sale" for fifteen days.Because in the november we left fifteen days. </P><P>An this will be for the sixteen days and go on.</P><P>And Please Assume that I choose a date from calendar. That is 05/03/2010. I should see sale amount for only three days. after one day this should be only for four day.</P><P></P><P>I can make this for 2011 but my formula fails for the previous years. You can see my formula in the attached file.</P><P></P><P></P><P>I am looking forward to seeing your support please.</P><P>Thanks in advance</P><P></P><P></P><P></P></BODY></HTML> Tue, 15 Nov 2011 15:03:42 GMT 2011-11-15T15:03:42Z Expression Help https://community.qlik.com/t5/QlikView/Expression-Help/m-p/321487#M118449 <HTML><HEAD></HEAD><BODY><P>Hi Dear Friends;</P><P></P><P>I need help by creating expression formula to calculate monthly based.</P><P></P><P>I want to calculate sales quantity. But I also want to calculate especially in a such way ;</P><P></P><P>When I select a date from calendar I want to see total calculate for "monthstart - selected date" period.</P><P></P><P>Forexample ; <STRONG>Today :</STRONG> 15.11.2011. So daily I want to show in the table "Monthly Sale" for fifteen days.Because in the november we left fifteen days. </P><P>An this will be for the sixteen days and go on.</P><P>And Please Assume that I choose a date from calendar. That is 05/03/2010. I should see sale amount for only three days. after one day this should be only for four day.</P><P></P><P>I can make this for 2011 but my formula fails for the previous years. You can see my formula in the attached file.</P><P></P><P></P><P>I am looking forward to seeing your support please.</P><P>Thanks in advance</P><P></P><P></P><P></P></BODY></HTML> Tue, 15 Nov 2011 15:03:42 GMT https://community.qlik.com/t5/QlikView/Expression-Help/m-p/321487#M118449 2011-11-15T15:03:42Z