topic Obtener porcentaje trimestral in App Development https://community.qlik.com/t5/App-Development/Obtener-porcentaje-trimestral/m-p/1536537#M38714 <P>Buenos días</P><P>Estoy buscando la forma de el el el Obtener el Porcentaje considerable trimestral y anual en BASADO Cierta Cantidad de Entradas abiertos y cerrados.</P><P>Como ejemplo tengo los campos Siguientes:</P><P>id&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fecha inicio&nbsp; &nbsp; &nbsp; &nbsp; Fecha última<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07/01/2018<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/2018<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;26/01/2018<BR />4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/01/2018<BR />5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/02/2018<BR />6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/02/2018&nbsp; &nbsp; &nbsp; &nbsp; 29/02/2018<BR />7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/032018<BR />8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;29/03/2018<BR />9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/05/2018<BR />&nbsp;</P><P>Teniendo en Cuenta los Datos Anteriores obtengo los&nbsp;tickest Que se abrieron y Cerraron Durante El Mismo mes y de esa forma obtengo el Porcentaje de Cumplimiento.</P><P>Algo&nbsp;como esto:</P><P>v.TicketsAbiertos = Count ({&lt;[Fecha inicio] = { "&gt; = $ (= min (Fecha (Fecha))) &lt;= $ (= max (Fecha (Fecha)))"}&gt;} Identification distint)</P><P>v.TicketsCerrados = Count ({&lt;[Fecha última] = { "&gt; = $ (= min (Fecha (Fecha))) &lt;= $ (= max (Fecha (Fecha)))"},<BR />[Fecha inicio] = { "&gt; = $ (= min (Fecha (Fecha))) &lt;= $ (= max (Fecha (Fecha)))"}&gt;} Distinto id)</P><P>El Porcentaje de Cumplimiento lo obtengo de la siguiente forma.</P><P>v.Cumplimiento = ((v.TicketsCerrados * 100) /v.TicketsAbiertos)</P><P>id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fecha inicio<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> Fecha última<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> MES <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN>abiertos <SPAN>&nbsp; &nbsp; &nbsp; </SPAN>Cerrados <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>Cumplimiento<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>&nbsp; 07/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;</SPAN>enero&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80,0<BR />2<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 01/01/2018<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;</SPAN>09/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;</SPAN>febrero&nbsp; &nbsp; &nbsp; 1 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>1 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>100,0<BR />3 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>01/01/2018<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;</SPAN> 26/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp;</SPAN>marzo<SPAN>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>3 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>1 <SPAN>&nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>33,3<BR />4<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 01/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>08/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; <STRONG>&nbsp;</STRONG></SPAN><STRONG>Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9 &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6 &nbsp;</STRONG><SPAN><STRONG>&nbsp;</STRONG> &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><STRONG>66,7</STRONG><BR />5 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>05/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>23/02/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />6 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>02/02/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>29/02/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />7<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 07/03/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>07/032018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />8<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 28/03/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>29/04/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />9 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>28/03/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>28/05/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<BR />&nbsp;</P><P>Parece La Forma Correcta teniendo en Cuenta La Cantidad de&nbsp;tickest abiertos y cerrados, sin embargo, Lo Que Necesito Obtener Es El Promedio de los Porcentajes de Cumplimiento, de esta forma:</P><P>Cantidad de meses = 3</P><P>((V.Cumplimientoenero + v.Cumplimientofebrero + v.Cumplimientomarzo) * 100) / 3</P><P>Cumplimiento<BR />80,0<BR />100,0<BR />33,3<BR /><STRONG>71,1</STRONG><BR />&nbsp;</P><P>Este es el resultado&nbsp;que deseo obtener.</P><P>Agradezco su ayuda.</P> Tue, 29 Jan 2019 13:45:58 GMT jscardona42 2019-01-29T13:45:58Z Obtener porcentaje trimestral https://community.qlik.com/t5/App-Development/Obtener-porcentaje-trimestral/m-p/1536537#M38714 <P>Buenos días</P><P>Estoy buscando la forma de el el el Obtener el Porcentaje considerable trimestral y anual en BASADO Cierta Cantidad de Entradas abiertos y cerrados.</P><P>Como ejemplo tengo los campos Siguientes:</P><P>id&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fecha inicio&nbsp; &nbsp; &nbsp; &nbsp; Fecha última<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07/01/2018<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/2018<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;26/01/2018<BR />4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08/01/2018<BR />5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05/01/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/02/2018<BR />6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/02/2018&nbsp; &nbsp; &nbsp; &nbsp; 29/02/2018<BR />7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07/032018<BR />8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;29/03/2018<BR />9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/05/2018<BR />&nbsp;</P><P>Teniendo en Cuenta los Datos Anteriores obtengo los&nbsp;tickest Que se abrieron y Cerraron Durante El Mismo mes y de esa forma obtengo el Porcentaje de Cumplimiento.</P><P>Algo&nbsp;como esto:</P><P>v.TicketsAbiertos = Count ({&lt;[Fecha inicio] = { "&gt; = $ (= min (Fecha (Fecha))) &lt;= $ (= max (Fecha (Fecha)))"}&gt;} Identification distint)</P><P>v.TicketsCerrados = Count ({&lt;[Fecha última] = { "&gt; = $ (= min (Fecha (Fecha))) &lt;= $ (= max (Fecha (Fecha)))"},<BR />[Fecha inicio] = { "&gt; = $ (= min (Fecha (Fecha))) &lt;= $ (= max (Fecha (Fecha)))"}&gt;} Distinto id)</P><P>El Porcentaje de Cumplimiento lo obtengo de la siguiente forma.</P><P>v.Cumplimiento = ((v.TicketsCerrados * 100) /v.TicketsAbiertos)</P><P>id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Fecha inicio<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> Fecha última<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> MES <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN>abiertos <SPAN>&nbsp; &nbsp; &nbsp; </SPAN>Cerrados <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>Cumplimiento<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2018<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>&nbsp; 07/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;</SPAN>enero&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80,0<BR />2<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 01/01/2018<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;</SPAN>09/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;</SPAN>febrero&nbsp; &nbsp; &nbsp; 1 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>1 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN>100,0<BR />3 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>01/01/2018<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;</SPAN> 26/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp;</SPAN>marzo<SPAN>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>3 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>1 <SPAN>&nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>33,3<BR />4<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 01/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>08/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; <STRONG>&nbsp;</STRONG></SPAN><STRONG>Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9 &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6 &nbsp;</STRONG><SPAN><STRONG>&nbsp;</STRONG> &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</SPAN><STRONG>66,7</STRONG><BR />5 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>05/01/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>23/02/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />6 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>02/02/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>29/02/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />7<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 07/03/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>07/032018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />8<SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN> 28/03/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>29/04/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />9 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>28/03/2018 <SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN>28/05/2018 &nbsp; &nbsp; &nbsp; &nbsp;<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<BR />&nbsp;</P><P>Parece La Forma Correcta teniendo en Cuenta La Cantidad de&nbsp;tickest abiertos y cerrados, sin embargo, Lo Que Necesito Obtener Es El Promedio de los Porcentajes de Cumplimiento, de esta forma:</P><P>Cantidad de meses = 3</P><P>((V.Cumplimientoenero + v.Cumplimientofebrero + v.Cumplimientomarzo) * 100) / 3</P><P>Cumplimiento<BR />80,0<BR />100,0<BR />33,3<BR /><STRONG>71,1</STRONG><BR />&nbsp;</P><P>Este es el resultado&nbsp;que deseo obtener.</P><P>Agradezco su ayuda.</P> Tue, 29 Jan 2019 13:45:58 GMT https://community.qlik.com/t5/App-Development/Obtener-porcentaje-trimestral/m-p/1536537#M38714 jscardona42 2019-01-29T13:45:58Z