topic Re: Best practice to link several different dates when applying filters in QlikView https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358767#M574515 <HTML><HEAD></HEAD><BODY><P>Hi!<BR />No problem!<BR />Please see the attached files that include the data model and the load scripts</P><P>Cliente = Customer</P><P>Casa Matriz = Home Office<BR />Fecha = Date</P><P>Dia = Day<BR />Mes = Month<BR />Año =&nbsp; Year</P><P>Ventas = Sales<BR />Llamadas = Calls</P><P>Please let me know if I can help you in any other way</P><P>Regards,</P></BODY></HTML> Mon, 23 Jul 2012 12:01:02 GMT 2012-07-23T12:01:02Z Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358758#M574506 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I have an app that has several different dates (for Sales, Market Share, Service requests, etc) and I want to find the best way of having a date filter that will filter them all together at some point and also be able to do it separately</P><P>Right now I am using set analysis on the expressions: <BR />count({&lt;MonthYearSI=MonthYear&gt;} SINumber)</P><P>This enables me to have the same selections for both dates but I don't know if there's a better practice, because now I am changing the layout to have 3 different date filters, Year, Quarter and Month<BR />Any suggestions will be deeply appreciated<BR />Regards,</P></BODY></HTML> Thu, 19 Jul 2012 13:30:55 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358758#M574506 2012-07-19T13:30:55Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358759#M574507 <HTML><HEAD></HEAD><BODY><P>He, Pablo.</P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">I</SPAN> <SPAN class="hps">use</SPAN> "<SPAN class="hps">autonumber"</SPAN> <SPAN class="hps">function.</SPAN></SPAN></P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">See the example</SPAN>.</SPAN></P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">I hope</SPAN> <SPAN class="hps">it helps.</SPAN></SPAN></P><P></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">Regards.<BR /></SPAN></SPAN></P></BODY></HTML> Thu, 19 Jul 2012 14:48:56 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358759#M574507 spividori 2012-07-19T14:48:56Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358760#M574508 <HTML><HEAD></HEAD><BODY><P>Muchas gracias Sandro</P><P></P><P>It helps if I only want to link by date, but I also need to link this to customer for instance and it will give me a synthetic key of keyfecha and keycustomer <BR />I will try to get rid of this, with your example I am a little bit closer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>I'll let you know how it went</P></BODY></HTML> Thu, 19 Jul 2012 18:15:40 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358760#M574508 2012-07-19T18:15:40Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358761#M574509 <HTML><HEAD></HEAD><BODY><P>Pablo.</P><P>Si es en español mejor, mi inglés es vía traductor.</P><P>Puedes agregarle también el cliente sin problemas, yo tengo armado un modelo muy complejo de esta forma y funciona fantástico y tiene fecha, cliente, producto y otros. Ahí te subo el ejemplo con cliente también.</P><P></P><P>Saludos.</P></BODY></HTML> Thu, 19 Jul 2012 19:05:25 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358761#M574509 spividori 2012-07-19T19:05:25Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358762#M574510 <HTML><HEAD></HEAD><BODY><P>Excelente!<BR />Mi problema es que las distintas fechas tienen 2 niveles de agregacion de clientes, algunas cosas las tengo por casa matriz y otras por sucursal. Por ejemplo ventas y llamadas a soporte las tengo a nivel de IDCliente y Share en el mercado lo tengo a nivel de casa Matriz. <BR />Mi tabla de clientes es algo asi<BR />ID Cliente,ID Matriz, Nombre Cliente<BR />AA,AA,Cliente1<BR />AB,AA,Cliente2</P><P>AC,AC,Cliente3<BR />AD,AC,Cliente4<BR />AE,AC,Cliente5</P><P>Ahi es donde genero una clave sintetica que no me deja avanzar (ID Cliente e ID Matriz), y no me he dado cuenta de como sacarla aun. Para 2 fechas con el mismo nivel de agregacion de cliente funciona barbaro!<BR />Tengo que cambiar todo el modelo, pero creo que voy en buen camino, quizas deba cambiar el modelo de la tabla de clientes<BR />Si puedo hoy armo un ejemplo cortito y lo subo<BR />Muchas gracias por la ayuda!</P></BODY></HTML> Thu, 19 Jul 2012 20:03:07 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358762#M574510 2012-07-19T20:03:07Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358763#M574511 <HTML><HEAD></HEAD><BODY><P>Hola Sandro<BR />Aca esta el modelo super simplificado, pero te da una idea de donde se me complica.<BR />No agregue Share porque es donde me queda la clave sintetica, para lo otro funciona barbaro como ves<BR />Sigo pensando en una solucion pero te dejo el modelo adjunto con los datos a ver si se te ocurre como<BR />Muchisimas gracias!</P></BODY></HTML> Thu, 19 Jul 2012 20:46:19 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358763#M574511 2012-07-19T20:46:19Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358764#M574512 <HTML><HEAD></HEAD><BODY><P>Hola Pablo.</P><P>Disculpas por la tradanza en responder.</P><P>Acá armé algo&nbsp; con lo que me pasaste, creo que qudó bien y la verdad espero te sirva porque lo tuve que trabajar un poco.</P><P>Es medio complejo el tema de las relaciones, pero una vez que lo entiendes es muy útil sobre todo para grandes proyectos cuando quieres tener todo relacionado.</P><P></P><P>Saludos.</P><P>Sandro.</P></BODY></HTML> Sat, 21 Jul 2012 10:47:33 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358764#M574512 spividori 2012-07-21T10:47:33Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358765#M574513 <HTML><HEAD></HEAD><BODY><P>Justo habia entrado para contestarte que lo habia resuelto.<BR />Al final con tu manera anterior. Al darme cuenta que solo tenia informacion para la casa matriz en Share, lo podia usar como un cliente y comun y despues hacer el link con la casa matriz.<BR />Te adjunto para que lo veas. Igual me gusto la solucion con un par de claves, que podre usarla seguramente para este u otro proposito<BR />Saludos y muchas gracias <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><BR />Pablo</P></BODY></HTML> Sat, 21 Jul 2012 22:44:43 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358765#M574513 2012-07-21T22:44:43Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358766#M574514 <HTML><HEAD></HEAD><BODY><P>Gusy, </P><P>Since i have the same situeation, would you mine translate this into english.&nbsp; </P></BODY></HTML> Sun, 22 Jul 2012 15:24:13 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358766#M574514 2012-07-22T15:24:13Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358767#M574515 <HTML><HEAD></HEAD><BODY><P>Hi!<BR />No problem!<BR />Please see the attached files that include the data model and the load scripts</P><P>Cliente = Customer</P><P>Casa Matriz = Home Office<BR />Fecha = Date</P><P>Dia = Day<BR />Mes = Month<BR />Año =&nbsp; Year</P><P>Ventas = Sales<BR />Llamadas = Calls</P><P>Please let me know if I can help you in any other way</P><P>Regards,</P></BODY></HTML> Mon, 23 Jul 2012 12:01:02 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358767#M574515 2012-07-23T12:01:02Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358768#M574516 <HTML><HEAD></HEAD><BODY><P>Thanks for your update. You are refering attachements from your previous post on Jul 21, 2012 6:44 PM ?</P></BODY></HTML> Sun, 29 Jul 2012 02:21:45 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358768#M574516 2012-07-29T02:21:45Z Re: Best practice to link several different dates when applying filters https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358769#M574517 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Just refer to this example with the translation and please let me know if you have any questions<BR />Regards,</P></BODY></HTML> Mon, 30 Jul 2012 12:48:07 GMT https://community.qlik.com/t5/QlikView/Best-practice-to-link-several-different-dates-when-applying/m-p/358769#M574517 2012-07-30T12:48:07Z