topic How to Calculate MTD in QlikView https://community.qlik.com/t5/QlikView/How-to-Calculate-MTD/m-p/180606#M46964 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P>How can I put the expression to calculate MTD? I have the following columns in the pivot table:-</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 453pt; border-collapse: collapse;" width="600"><COLGROUP><COL style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243; mso-outline-parent: collapsed;" width="34" /><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413; mso-outline-parent: collapsed;" width="66" /><COL style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048; mso-outline-parent: collapsed;" width="56" /><COL style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523; mso-outline-parent: collapsed;" width="69" /><COL style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755; mso-outline-parent: collapsed;" width="48" /><COL style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755; mso-outline-parent: collapsed;" width="48" /><COL style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121; mso-outline-parent: collapsed;" width="58" /><COL style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755; mso-outline-parent: collapsed;" width="48" /><COL style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609; mso-outline-parent: collapsed;" width="44" /><COL style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499; mso-outline-parent: collapsed;" width="41" /><COL style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121; mso-outline-parent: collapsed;" width="58" /><COL style="width: 23pt; mso-width-source: userset; mso-width-alt: 1097; mso-outline-parent: collapsed;" width="30" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: silver; width: 26pt; height: 12.75pt; border: white 0.5pt solid;" width="34"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; width: 50pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="66"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; width: 42pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="56"><STRONG></STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; width: 52pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="69"><STRONG></STRONG></TD><TD class="xl79" colspan="4" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; width: 152pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="202">Today</TD><TD class="xl76" colspan="4" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 131pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="173">MTD</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: silver; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; border-top: white; border-right: white 0.5pt solid;"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; border-top: white; border-right: white 0.5pt solid;"><STRONG></STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>DChl</STRONG></TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DC</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DE</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">IT</TD><TD class="xl69" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DC</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DE</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">IT</TD><TD class="xl69" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: #d2d2d2; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;"><STRONG>Plant</STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>Group</STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>SO Name</STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>MCounty</STRONG></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl71" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl71" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;">NE02</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGKNG</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGK</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">Ahmedabad</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">209.470</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">212.000</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">502.000</TD><TD align="right" class="xl73" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white 0.5pt solid; border-right: white 0.5pt solid;">923.470</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl74" style="border-bottom: white 0.5pt solid; border-left: white; background-color: whitesmoke; border-top: white 0.5pt solid; border-right: white 0.5pt solid;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;">NE02</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGKNG</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGK</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">Gandhinagar</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">17.180</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">44.000</TD><TD class="xl75" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD align="right" class="xl73" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">61.180</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD class="xl74" style="border-bottom: white 0.5pt solid; border-left: white; background-color: whitesmoke; border-top: white; border-right: white 0.5pt solid;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;">NE02</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGKNG</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGK</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">Kheda</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">17.000</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">129.000</TD><TD class="xl75" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD align="right" class="xl73" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">146.000</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD class="xl74" style="border-bottom: white 0.5pt solid; border-left: white; background-color: whitesmoke; border-top: white; border-right: white 0.5pt solid;">-</TD></TR></TBODY></TABLE><BR /><BR /></BODY></HTML> Fri, 25 Mar 2011 07:20:00 GMT 2011-03-25T07:20:00Z How to Calculate MTD https://community.qlik.com/t5/QlikView/How-to-Calculate-MTD/m-p/180606#M46964 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P>How can I put the expression to calculate MTD? I have the following columns in the pivot table:-</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 453pt; border-collapse: collapse;" width="600"><COLGROUP><COL style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243; mso-outline-parent: collapsed;" width="34" /><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413; mso-outline-parent: collapsed;" width="66" /><COL style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048; mso-outline-parent: collapsed;" width="56" /><COL style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523; mso-outline-parent: collapsed;" width="69" /><COL style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755; mso-outline-parent: collapsed;" width="48" /><COL style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755; mso-outline-parent: collapsed;" width="48" /><COL style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121; mso-outline-parent: collapsed;" width="58" /><COL style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755; mso-outline-parent: collapsed;" width="48" /><COL style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609; mso-outline-parent: collapsed;" width="44" /><COL style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499; mso-outline-parent: collapsed;" width="41" /><COL style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121; mso-outline-parent: collapsed;" width="58" /><COL style="width: 23pt; mso-width-source: userset; mso-width-alt: 1097; mso-outline-parent: collapsed;" width="30" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: silver; width: 26pt; height: 12.75pt; border: white 0.5pt solid;" width="34"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; width: 50pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="66"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; width: 42pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="56"><STRONG></STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; width: 52pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="69"><STRONG></STRONG></TD><TD class="xl79" colspan="4" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; width: 152pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="202">Today</TD><TD class="xl76" colspan="4" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; width: 131pt; border-top: white 0.5pt solid; border-right: white 0.5pt solid;" width="173">MTD</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: silver; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; border-top: white; border-right: white 0.5pt solid;"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: white 0.5pt solid; border-left: white; background-color: silver; border-top: white; border-right: white 0.5pt solid;"><STRONG></STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>DChl</STRONG></TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DC</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DE</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">IT</TD><TD class="xl69" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DC</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">DE</TD><TD class="xl68" style="border-bottom: #ece9d8; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">IT</TD><TD class="xl69" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: #d2d2d2; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;"><STRONG>Plant</STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>Group</STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>SO Name</STRONG></TD><TD class="xl66" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #d2d2d2; border-top: white; border-right: white 0.5pt solid;"><STRONG>MCounty</STRONG></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl71" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl70" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: #ece9d8; border-right: white 0.5pt solid;"></TD><TD class="xl71" style="border-bottom: #ece9d8; border-left: white; background-color: whitesmoke; border-top: #ece9d8; border-right: white 0.5pt solid;">Total</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;">NE02</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGKNG</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGK</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">Ahmedabad</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">209.470</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">212.000</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">502.000</TD><TD align="right" class="xl73" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white 0.5pt solid; border-right: white 0.5pt solid;">923.470</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl74" style="border-bottom: white 0.5pt solid; border-left: white; background-color: whitesmoke; border-top: white 0.5pt solid; border-right: white 0.5pt solid;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;">NE02</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGKNG</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGK</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">Gandhinagar</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">17.180</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">44.000</TD><TD class="xl75" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD align="right" class="xl73" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">61.180</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD class="xl74" style="border-bottom: white 0.5pt solid; border-left: white; background-color: whitesmoke; border-top: white; border-right: white 0.5pt solid;">-</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: white 0.5pt solid; border-left: white 0.5pt solid; background-color: white; height: 12.75pt; border-top: white; border-right: white 0.5pt solid;">NE02</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGKNG</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">AGK</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">Kheda</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">17.000</TD><TD align="right" class="xl72" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">129.000</TD><TD class="xl75" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD align="right" class="xl73" style="border-bottom: white 0.5pt solid; border-left: white; background-color: #e4f9fa; border-top: white; border-right: white 0.5pt solid;">146.000</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">-</TD><TD class="xl67" style="border-bottom: white 0.5pt solid; border-left: white; background-color: white; border-top: white; border-right: white 0.5pt solid;">NIL</TD><TD class="xl74" style="border-bottom: white 0.5pt solid; border-left: white; background-color: whitesmoke; border-top: white; border-right: white 0.5pt solid;">-</TD></TR></TBODY></TABLE><BR /><BR /></BODY></HTML> Fri, 25 Mar 2011 07:20:00 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-MTD/m-p/180606#M46964 2011-03-25T07:20:00Z How to Calculate MTD https://community.qlik.com/t5/QlikView/How-to-Calculate-MTD/m-p/180607#M46965 <HTML><HEAD></HEAD><BODY><P>In the past I've used: (unchecked syntax)</P><P>=sum(if(monthname(DateField)=monthname(today()) and date(DateField)&lt;=date(today()),Sales))</P><P>Alternatively of course you can use the InMonthToDate() function.</P><P>Hope that helps,</P><P>Matt - Visual Analytics Ltd</P></BODY></HTML> Fri, 25 Mar 2011 08:48:22 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-MTD/m-p/180607#M46965 matt_crowther 2011-03-25T08:48:22Z