5 Replies Latest reply: Jan 3, 2014 2:50 PM by Sandro Pividori RSS

    ayuda

    jose jose

      como puedo saber  los clientes  x nombre que  no se  repiten en un determinada fecha ejemplo

      contar los clientes entre  fecha=01-01-2013 and  fecha <= 31-01-2013 and  que el cliente no este en fechas anteriores

      y cliente no este en fecha <= 31-12-2013

        • Re: ayuda
          Ivan Trayanov

          I don't  speak Spanish but you can try something like this


          Count( {$<P({1<fecha>={‘01-01-2013’},fecha<={‘31-01-2013’}>}),E({1<fecha<={‘31-12-2013’}>} cliente)>} cliente)


          I am not sure if this will work with the dates. I will prefer to create Month, and Year fields.



            • Re: ayuda
              jose jose

              THANKS I WILL TRY AND MONTH-YEAR AS SERIOUSSHIPPING AND MODEL TE QUERTES

              JOSE  LUIS

              Date: Tue, 31 Dec 2013 15:30:03 -0500

              From: qcwebmaster@qlik.com

              To: jorquerajl@hotmail.com

              Subject: Re:  - ayuda

               

               

               

               

               

               

                    

                         

                              

               

                                   

               

                                        

                                             

                                                  

                                                       

                                                            

                                                           QlikCommunity

                                                       

               

                                                  

                                                  

                                                       

              ayuda

               

               

              reply from Ivan Trayanov in Creating Analytics - View the full discussion

               

               

               

               

              I don't  speak Spanish but you can try something like this

               

               

               

              Count( {$} cliente)

               

               

              I am not sure if this will work with the dates. I will prefer to create Month, and Year fields.

               

               

               

               

               

               

               

               

               

                    

                    

                    

                   Reply to this message by replying to this email, or go to the message on QlikCommunity

                   

                   

                    

                    

                   Start a new discussion in Creating Analytics by email or at QlikCommunity

                    

                   

               

                   

                    

                   Following ayuda in these streams:

                   Inbox

                                                                                              © 1993-2013 QlikTech International AB   

                           

                          Copyright & Trademarks | Privacy | Terms of Use | Software EULA

            • Re: ayuda
              Sandro Pividori

              Hola.

              No se si ya resolviste este tema pero te paso un link que quizá te pueda ayudar:

              http://community.qlik.com/thread/86223

               

              Saludos.

                • Re: ayuda
                  jose jose

                  Date: Fri, 3 Jan 2014 13:55:01 -0500

                  From: qcwebmaster@qlik.com

                  To: jorquerajl@hotmail.com

                  Subject: Re:  - ayuda

                   

                   

                   

                   

                   

                   

                        

                             

                                  

                   

                                       

                   

                                            

                                                 

                                                      

                                                           

                                                                

                                                               QlikCommunity

                                                           

                   

                                                      

                                                      

                                                           

                  ayuda

                   

                   

                  reply from Sandro Pividori in Creating Analytics - View the full discussion

                   

                   

                   

                   

                  Hola.

                  No se si ya resolviste este tema pero te paso un link que quizá te pueda ayudar:

                  http://community.qlik.com/thread/86223

                  Saludos.

                   

                   

                   

                   

                        

                        

                        

                       Reply to this message by replying to this email, or go to the message on QlikCommunity

                       

                       

                        

                        

                       Start a new discussion in Creating Analytics by email or at QlikCommunity

                        

                       

                   

                       

                        

                       Following ayuda in these streams:

                       Inbox

                                                                                                  © 1993-2013 QlikTech International AB   

                               

                              Copyright & Trademarks | Privacy | Terms of Use | Software EULA

                    • Re: ayuda
                      Sandro Pividori

                      Hola.

                      Lo podrías resolver de la siguiente manera:

                      TblBase:

                      load distinct NOMBRE

                      where FECHA <='2012-12-31';

                      SQL SELECT NOMBRE

                      FROM [FRONT].[dbo].[131 AUDITORIA FONDO];

                       

                      Nuevos:

                      load distinct NOMBRE as N_NOMBRE

                      where fecha >='2013-01-01' and  fecha <='2013-01-31' and not exists(NOMBRE);

                      SQL SELECT NOMBRE

                      FROM [FRONT].[dbo].[131 AUDITORIA FONDO];

                       

                      Saludos.