<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: OPTIMIZACIÓN CONTEO IF in Español</title>
    <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76216#M802</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Gracias Héctor&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;El QVF pesa 1.50 GB no le puedo adjuntar &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Se puede realizar el Pick en un script para que me guarde en un QDV para así no realizar el calculo en el QVF ¿como podría cambiarle a script o se mantiene el mismo formato?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 27 Jun 2018 17:39:54 GMT</pubDate>
    <dc:creator>kstronemesis</dc:creator>
    <dc:date>2018-06-27T17:39:54Z</dc:date>
    <item>
      <title>OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76212#M798</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Buenos Días,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Por favor me pueden ayudar a optimizar el siguiente script ya que al momento de mostrar información en los tableros me da TimeOut pero cuando filtro por unos pocos datos me despliega información &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;El script que tengo es el siguiente&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;MES DESTINATARIO&lt;/P&gt;&lt;P&gt;=if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=1,'MES 1',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=2,'MES 2',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=3,'MES 3',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=4,'MES 4',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=5,'MES 5',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=6,'MES 6',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=7,'MES 7',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=8,'MES 8',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=9,'MES 9',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=10,'MES 10',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=11,'MES 11',&lt;/P&gt;&lt;P&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=12,'MES 12',&lt;/P&gt;&lt;P&gt;))))))))))))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;TOTAL MESES&lt;/P&gt;&lt;P&gt;count(distinct TRA_DESTINATARIO)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;PORCENTAJE&lt;/P&gt;&lt;P&gt;count(distinct TRA_DESTINATARIO)/sum(total(Aggr(count(distinct TRA_DESTINATARIO),TRA_DESTINATARIO)))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Filtro con pocos datos maestra información &lt;/P&gt;&lt;P&gt;&lt;A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1505843-205953/pastedImage_2.png"&gt;&lt;IMG alt="" class="jive-image image-1" height="224" src="https://community.qlik.com/legacyfs/online/206145_pastedImage_2.png" style="height: 224px; width: 768.332px;" width="768" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Pero cuando quiero que me despliegue la información de todo un año o mas me da TimeOut como puedo optimizar los cálculos o que puedo hacer? &lt;/P&gt;&lt;P&gt;&lt;A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1505843-205954/pastedImage_3.png"&gt;&lt;IMG alt="" class="jive-image image-2" height="445" src="https://community.qlik.com/legacyfs/online/206146_pastedImage_3.png" width="1343" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P class="jive-thread-reply-btn"&gt;&lt;/P&gt;&lt;DIV class="jive-thread-reply-btn-correct"&gt;&lt;A _jive_internal="true" href="https://community.qlik.com/message/1505843"&gt;&lt;SPAN class="j-correct-btn-star j-ui-elem"&gt;&lt;/SPAN&gt;Respuesta correcta&lt;/A&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 25 Jun 2018 14:33:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76212#M798</guid>
      <dc:creator>kstronemesis</dc:creator>
      <dc:date>2018-06-25T14:33:31Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76213#M799</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hola Miguel,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Al menos la expresión:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;=if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=1,'MES 1',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=2,'MES 2',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=3,'MES 3',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=4,'MES 4',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=5,'MES 5',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=6,'MES 6',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=7,'MES 7',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=8,'MES 8',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=9,'MES 9',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=10,'MES 10',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=11,'MES 11',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;if (Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)=12,'MES 12',&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;))))))))))))&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;, la podrías simplificar de la siguiente forma:&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;=Pick(&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO), &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 'MES 1', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 'MES 2', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 3', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 4', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 5', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 6', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 7', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 8', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 9', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 10', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 11', &lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;'MES 12')&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;, así solo se evaluaría "&lt;SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"&gt;Aggr(count(distinct Mes_Registro),TRA_DESTINATARIO)&lt;/SPAN&gt;" una sola vez. Si además esta expresión Aggr() la usas en más sitios, podrías crearte una variable.&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;Espero que te ayude... La función Pick() es muy útil para estos casos (mira también la función Match() porque ambas combinadas te pueden ayudar en casos similares).&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;Saludos,&lt;BR /&gt;&lt;/SPAN&gt;&lt;BR /&gt;H&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 26 Jun 2018 02:58:26 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76213#M799</guid>
      <dc:creator>hector_munoz</dc:creator>
      <dc:date>2018-06-26T02:58:26Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76214#M800</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hola Héctor,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Le cambie por la función Pick, y filtro por año me sigue dando TimeOut , filtro por algunos destinatarios me funciona y me despliega información hay alguna forma mas de optimizar porque la información que tengo es mucha&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/206318_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 26 Jun 2018 19:16:36 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76214#M800</guid>
      <dc:creator>kstronemesis</dc:creator>
      <dc:date>2018-06-26T19:16:36Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76215#M801</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;¿Puedes adjuntar la app para que te ayudemos?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 27 Jun 2018 03:25:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76215#M801</guid>
      <dc:creator>hector_munoz</dc:creator>
      <dc:date>2018-06-27T03:25:49Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76216#M802</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Gracias Héctor&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;El QVF pesa 1.50 GB no le puedo adjuntar &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Se puede realizar el Pick en un script para que me guarde en un QDV para así no realizar el calculo en el QVF ¿como podría cambiarle a script o se mantiene el mismo formato?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 27 Jun 2018 17:39:54 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76216#M802</guid>
      <dc:creator>kstronemesis</dc:creator>
      <dc:date>2018-06-27T17:39:54Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76217#M803</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hola Miguel,&lt;/P&gt;&lt;P&gt;Si el cálculo que necesitas no es susceptible de verse modificado por las selecciones que haga el usuario entonces sí que lo podrías hacer en el script, sin duda.&lt;/P&gt;&lt;P&gt;Saludos,&lt;/P&gt;&lt;P&gt;H&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 Jun 2018 02:50:29 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76217#M803</guid>
      <dc:creator>hector_munoz</dc:creator>
      <dc:date>2018-06-28T02:50:29Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76218#M804</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Gracias por tu ayuda Héctor y el formato se mantiene el mismo?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 29 Jun 2018 15:59:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76218#M804</guid>
      <dc:creator>kstronemesis</dc:creator>
      <dc:date>2018-06-29T15:59:16Z</dc:date>
    </item>
    <item>
      <title>Re: OPTIMIZACIÓN CONTEO IF</title>
      <link>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76219#M805</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="font-size: 13.3333px;"&gt;Hola Miguel,&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;En script no puedes usar Aggr(), ya que es una función de gráfico, sino que tienes que hacer GROUP BY.&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;Algo así como:&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="font-family: 'courier new', courier;"&gt;LOAD&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;SPAN style="color: #3d3d3d; font-size: 12px;"&gt;TRA_DESTINATARIO&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AS &lt;SPAN style="color: #3d3d3d; font-size: 12px;"&gt;TRA_DESTINATARIO&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'courier new', courier;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Count(DISTINCT &lt;SPAN style="color: #3d3d3d; font-size: 12px;"&gt;Mes_Registro) AS NUM_MESES&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'courier new', courier; font-size: 12px;"&gt;RESDENT&amp;nbsp;&amp;nbsp; XXXXXXXXX&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="font-family: 'courier new', courier;"&gt;GROUP BY&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'courier new', courier;"&gt;TRA_DESTINATARIO;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;Y luego ya en los objetos usas una expresión similar a:&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;Pick(&lt;SPAN style="color: #3d3d3d; font-family: 'courier new', courier; font-size: 12px;"&gt;NUM_MESES, 'MES 1', 'MES2', ...)&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'courier new', courier;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'courier new', courier;"&gt;Espero que te sirva,&lt;/SPAN&gt;&lt;/P&gt;&lt;P style="font-size: 13.3333px;"&gt;&lt;SPAN style="color: #3d3d3d; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"&gt;&lt;SPAN style="color: #3d3d3d; font-family: 'courier new', courier; font-size: 12px;"&gt;H&lt;/SPAN&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 30 Jun 2018 04:47:55 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Espa%C3%B1ol/OPTIMIZACI%C3%93N-CONTEO-IF/m-p/76219#M805</guid>
      <dc:creator>hector_munoz</dc:creator>
      <dc:date>2018-06-30T04:47:55Z</dc:date>
    </item>
  </channel>
</rss>

