topic max period in QlikView https://community.qlik.com/t5/QlikView/max-period/m-p/511257#M191007 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i need to show value fromthe <SPAN class="hps">Current month only .</SPAN></P><P><SPAN class="hps"></SPAN>i wrote :</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;">outgatedate</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"*$(date(Today(),'MM-YYYY'))"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">TAMASHDATEKey</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"D*"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">sumkg</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">when i chose may or any other month ( not june) the value stiil apear.</SPAN></P><P><SPAN style="font-size: 8pt;">what did i write wrong ? </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">thanks'</SPAN></P><P><SPAN style="font-size: 8pt;">yarin.</SPAN></P></BODY></HTML> Wed, 26 Jun 2013 13:12:05 GMT Anonymous 2013-06-26T13:12:05Z max period https://community.qlik.com/t5/QlikView/max-period/m-p/511257#M191007 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i need to show value fromthe <SPAN class="hps">Current month only .</SPAN></P><P><SPAN class="hps"></SPAN>i wrote :</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;">outgatedate</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"*$(date(Today(),'MM-YYYY'))"</SPAN><SPAN style="font-size: 8pt;">},</SPAN><SPAN style="color: #800000; font-size: 8pt;">TAMASHDATEKey</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"D*"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">sumkg</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">when i chose may or any other month ( not june) the value stiil apear.</SPAN></P><P><SPAN style="font-size: 8pt;">what did i write wrong ? </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">thanks'</SPAN></P><P><SPAN style="font-size: 8pt;">yarin.</SPAN></P></BODY></HTML> Wed, 26 Jun 2013 13:12:05 GMT https://community.qlik.com/t5/QlikView/max-period/m-p/511257#M191007 Anonymous 2013-06-26T13:12:05Z