topic Need current month in QlikView https://community.qlik.com/t5/QlikView/Need-current-month/m-p/454729#M169659 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have this expression for <STRONG>straight table</STRONG> in which I need to subtract the value of current month, the expression is...</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=</P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.Flag</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"Gross Billings"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.MonthlyBillings</SPAN><SPAN style="font-size: 8pt;">) -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // this is gross billing field</SPAN><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.Flag</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"P6Data"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.MonthlyBillings</SPAN><SPAN style="font-size: 8pt;">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //need current month for this field everytime i subtract.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">the field name from were we are taking month is<STRONG> Historical.billing_date</STRONG> just in case we need it...</SPAN></P></BODY></HTML> Mon, 10 Jun 2013 06:35:43 GMT 2013-06-10T06:35:43Z Need current month https://community.qlik.com/t5/QlikView/Need-current-month/m-p/454729#M169659 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have this expression for <STRONG>straight table</STRONG> in which I need to subtract the value of current month, the expression is...</P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>=</P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.Flag</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"Gross Billings"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.MonthlyBillings</SPAN><SPAN style="font-size: 8pt;">) -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // this is gross billing field</SPAN><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.Flag</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"P6Data"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Historical_Billing.MonthlyBillings</SPAN><SPAN style="font-size: 8pt;">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //need current month for this field everytime i subtract.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">the field name from were we are taking month is<STRONG> Historical.billing_date</STRONG> just in case we need it...</SPAN></P></BODY></HTML> Mon, 10 Jun 2013 06:35:43 GMT https://community.qlik.com/t5/QlikView/Need-current-month/m-p/454729#M169659 2013-06-10T06:35:43Z