topic YTD with condition in QlikView https://community.qlik.com/t5/QlikView/YTD-with-condition/m-p/693821#M250914 <HTML><HEAD></HEAD><BODY><P>I have to show YTD with condition like if&nbsp; month selected is complete show YTD, if it is not complete(for ex: July 25,2014) show till June data.</P><P></P><P>like monthend(max(Calendermonthyear)=max(calendermonthyear), max(calendermonthyear)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; monthend(max(Calendermonthyear)&gt;max(calendermonthyear),max(calendermonthyear)-1</P><P></P><P>right now Iam using this to find YTD</P><P><IMG alt="Capture.PNG" class="jive-image" src="https://community.qlik.com/legacyfs/online/63509_Capture.PNG" /></P><P></P><P>How do I modify expression to show above condition?</P></BODY></HTML> Thu, 31 Jul 2014 17:31:41 GMT Anonymous 2014-07-31T17:31:41Z YTD with condition https://community.qlik.com/t5/QlikView/YTD-with-condition/m-p/693821#M250914 <HTML><HEAD></HEAD><BODY><P>I have to show YTD with condition like if&nbsp; month selected is complete show YTD, if it is not complete(for ex: July 25,2014) show till June data.</P><P></P><P>like monthend(max(Calendermonthyear)=max(calendermonthyear), max(calendermonthyear)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; monthend(max(Calendermonthyear)&gt;max(calendermonthyear),max(calendermonthyear)-1</P><P></P><P>right now Iam using this to find YTD</P><P><IMG alt="Capture.PNG" class="jive-image" src="https://community.qlik.com/legacyfs/online/63509_Capture.PNG" /></P><P></P><P>How do I modify expression to show above condition?</P></BODY></HTML> Thu, 31 Jul 2014 17:31:41 GMT https://community.qlik.com/t5/QlikView/YTD-with-condition/m-p/693821#M250914 Anonymous 2014-07-31T17:31:41Z