topic Re: Problems with YTD expression in App Development https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179214#M21722 <HTML><HEAD></HEAD><BODY><P>I would suggest using flags with a master calendar to avoid the hassle altogether <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A></P></BODY></HTML> Sun, 31 Jul 2016 08:03:59 GMT vinieme12 2016-07-31T08:03:59Z Problems with YTD expression https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179211#M21719 <HTML><HEAD></HEAD><BODY><P>Morning,</P><P></P><P>I have some problems with an expression.</P><P></P><P>Count({$&lt;Año={$(=Max(Año))},Fecha={&lt;=$(=max(Fecha))}&gt;}KEYPED)</P><P></P><P>Im trying to calculate the YTD (Year to date) number of orders.</P><P></P><P>Thank you in advance.</P><P></P><P>Manuel Coterillo</P></BODY></HTML> Sat, 16 Nov 2024 10:28:55 GMT https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179211#M21719 2024-11-16T10:28:55Z Re: Problems with YTD expression https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179212#M21720 <HTML><HEAD></HEAD><BODY><P>What is the issue you are running into? Have you checked Fecha is dual field where you can find its Max and also can have Less than equal to (<STRONG>&lt;=</STRONG>) check?</P></BODY></HTML> Sat, 30 Jul 2016 17:11:25 GMT https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179212#M21720 sunny_talwar 2016-07-30T17:11:25Z Re: Problems with YTD expression https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179213#M21721 <HTML><HEAD></HEAD><BODY><P>Hola,</P><P></P><P>Si usted está tratando de conseguir este año que va del año y si su ejercicio se inicia a partir de enero Mes entonces todo lo que necesita hacer es.</P><P></P><P>Count ({$ &lt;Año = {$ (= Max (OAN))}&gt;} KEYPED)</P><P></P><P>Si el mes comienza a partir de abril, entonces debería probar esto.</P><P></P><P>Count ({$ &lt;Fecha = { "&gt; = $ (= Yearstart (Max (Fecha), 0,4))"}&gt;} KEYPED)</P><P></P><P>Para obtener más información sobre dicho cálculo echar un vistazo a el siguiente enlace.</P><P></P><P><A class="jive-link-wiki-small" data-containerid="2049" data-containertype="14" data-objectid="9162" data-objecttype="102" href="https://community.qlik.com/docs/DOC-9162">https://community.qlik.com/docs/DOC-9162</A></P><P></P><P>Saludos,</P><P>Kaushik Solanki</P></BODY></HTML> Sun, 31 Jul 2016 07:56:42 GMT https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179213#M21721 kaushiknsolanki 2016-07-31T07:56:42Z Re: Problems with YTD expression https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179214#M21722 <HTML><HEAD></HEAD><BODY><P>I would suggest using flags with a master calendar to avoid the hassle altogether <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A></P></BODY></HTML> Sun, 31 Jul 2016 08:03:59 GMT https://community.qlik.com/t5/App-Development/Problems-with-YTD-expression/m-p/1179214#M21722 vinieme12 2016-07-31T08:03:59Z