topic Re: Search key in QlikView https://community.qlik.com/t5/QlikView/Search-key/m-p/1321836#M409482 <HTML><HEAD></HEAD><BODY><P>Hola!</P><P></P><P>Utilizar esta. Rango = 1 le dará la fecha máxima para ese ID.</P><P></P><P>Fact: </P><P>Load * Inline [</P><P>ID, Date, Sales</P><P>1,1/1/2017, 1</P><P>2,1/1/2017, 1</P><P>2,2/1/2017, 1</P><P>2,3/1/2017, 1</P><P>3,1/1/2017, 1</P><P>3,2/1/2017, 1</P><P>3,3/1/2017, 1</P><P>3,4/1/2017, 1];</P><P></P><P></P><P>LEFT JOIN (Fact)</P><P>LOAD</P><P>ID,Date</P><P>,if(ID=previous(ID) and Date&lt;Previous([Date]) , peek(Rank)+1,1) as Rank</P><P>RESIDENT Fact</P><P>ORDER BY ID,Date desc ;</P><P></P><P>Result:</P><P><IMG alt="Rank1.PNG" class="jive-image image-2" height="122" src="https://community.qlik.com/legacyfs/online/170443_Rank1.PNG" style="font-size: 13.3333px; height: 122px; width: 140.442px;" width="141" /><IMG alt="Rank.PNG" class="jive-image image-1" height="75" src="https://community.qlik.com/legacyfs/online/170442_Rank.PNG" style="height: 75px; width: 333.482px;" width="334" /></P><P></P><P>Cheers!</P></BODY></HTML> Mon, 17 Jul 2017 19:13:27 GMT manas_bn 2017-07-17T19:13:27Z Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321831#M409477 <HTML><HEAD></HEAD><BODY><P>Hola a todos!</P><P></P><P>Tengo un campo Llave <SPAN style="color: #339966;"><STRONG>(color verde)</STRONG></SPAN> que se repite N veces, ¿Como puedo obtener la fecha mayor asociada a ese campo llave?</P><P>resultado: </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="160"><TBODY><TR><TD class="xl63" height="17" width="80">Llave</TD><TD class="xl63" width="80">Fecha</TD></TR><TR><TD class="xl64" height="17">152855</TD><TD class="xl65">2017-07-07</TD></TR><TR><TD class="xl64" height="17">153281</TD><TD class="xl65">2017-07-15</TD></TR><TR><TD class="xl64" height="17">157927</TD><TD class="xl65">2017-07-17</TD></TR></TBODY></TABLE><P></P><P>Datos:</P><P><IMG alt="compras.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170448_compras.png" style="height: 296px; width: 620px;" /></P><P></P><P>mil gracias</P></BODY></HTML> Mon, 17 Jul 2017 18:28:31 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321831#M409477 2017-07-17T18:28:31Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321832#M409478 <HTML><HEAD></HEAD><BODY><P>may be</P><P><SPAN lang="es">Eliminar la dimensión Fetcha y utilizar expresssion max (Fetcha)</SPAN></P></BODY></HTML> Mon, 17 Jul 2017 18:49:40 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321832#M409478 aarkay29 2017-07-17T18:49:40Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321833#M409479 <HTML><HEAD></HEAD><BODY><P>Hola gracias por ayudarme,&nbsp; pero el max retorna el mismo valor del campo fecha, en lo cual no está evaluando todas las lineas que contienen la llave.</P><P><IMG alt="compas2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170449_compas2.png" style="height: 252px; width: 620px;" /></P><P>mil gracias</P></BODY></HTML> Mon, 17 Jul 2017 18:56:00 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321833#M409479 2017-07-17T18:56:00Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321834#M409480 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #222222; font-family: arial; font-size: 13.3333px; text-align: justify;">Eliminar la dimensión/Field Fecha</SPAN></P></BODY></HTML> Mon, 17 Jul 2017 18:58:47 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321834#M409480 aarkay29 2017-07-17T18:58:47Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321835#M409481 <HTML><HEAD></HEAD><BODY><P>Perdón intenta esto</P><P>max(total&lt;Llave&gt; Fecha)</P></BODY></HTML> Mon, 17 Jul 2017 19:06:47 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321835#M409481 aarkay29 2017-07-17T19:06:47Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321836#M409482 <HTML><HEAD></HEAD><BODY><P>Hola!</P><P></P><P>Utilizar esta. Rango = 1 le dará la fecha máxima para ese ID.</P><P></P><P>Fact: </P><P>Load * Inline [</P><P>ID, Date, Sales</P><P>1,1/1/2017, 1</P><P>2,1/1/2017, 1</P><P>2,2/1/2017, 1</P><P>2,3/1/2017, 1</P><P>3,1/1/2017, 1</P><P>3,2/1/2017, 1</P><P>3,3/1/2017, 1</P><P>3,4/1/2017, 1];</P><P></P><P></P><P>LEFT JOIN (Fact)</P><P>LOAD</P><P>ID,Date</P><P>,if(ID=previous(ID) and Date&lt;Previous([Date]) , peek(Rank)+1,1) as Rank</P><P>RESIDENT Fact</P><P>ORDER BY ID,Date desc ;</P><P></P><P>Result:</P><P><IMG alt="Rank1.PNG" class="jive-image image-2" height="122" src="https://community.qlik.com/legacyfs/online/170443_Rank1.PNG" style="font-size: 13.3333px; height: 122px; width: 140.442px;" width="141" /><IMG alt="Rank.PNG" class="jive-image image-1" height="75" src="https://community.qlik.com/legacyfs/online/170442_Rank.PNG" style="height: 75px; width: 333.482px;" width="334" /></P><P></P><P>Cheers!</P></BODY></HTML> Mon, 17 Jul 2017 19:13:27 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321836#M409482 manas_bn 2017-07-17T19:13:27Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321837#M409483 <HTML><HEAD></HEAD><BODY><P>Muchas gracias... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Mon, 17 Jul 2017 19:31:26 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321837#M409483 2017-07-17T19:31:26Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321838#M409484 <HTML><HEAD></HEAD><BODY><P>Muchas gracias <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Mon, 17 Jul 2017 19:31:35 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321838#M409484 2017-07-17T19:31:35Z Re: Search key https://community.qlik.com/t5/QlikView/Search-key/m-p/1321839#M409485 <HTML><HEAD></HEAD><BODY><P>¡Bienvenido! Por favor marque como contestado para que la discusión esté cerrada.</P></BODY></HTML> Mon, 17 Jul 2017 21:06:03 GMT https://community.qlik.com/t5/QlikView/Search-key/m-p/1321839#M409485 manas_bn 2017-07-17T21:06:03Z