Re: ayuda - Qlik Community

jose123456 · ‎2013-12-31

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

iktrayanov · ‎2013-12-31

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.

jose123456 · ‎2013-12-31

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

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

spividori · ‎2014-01-03

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.

jose123456 · ‎2014-01-03

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

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

spividori · ‎2014-01-03

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.