topic Re: New customer in QlikView

New customer

spividori — Fri, 05 Jul 2013 19:37:11 GMT

Hi.

I want to know how many new customers bought in the selected period.

In the attached example, in the period 09/2013 I have customers A, G and H, I should have G and H, because A has already bought.

Regards.

luciancotea — Fri, 05 Jul 2013 21:20:07 GMT

=Sum({1< >} aggr( if((min({1< >} Total <Cliente> Fecha)) = min(Fecha),1,0), Cliente))

rajni_batra — Sat, 06 Jul 2013 06:02:03 GMT

hi lucian will you plz expalin what {1< >} does ?

I have never used this thing,,

Thanks,

luciancotea — Sat, 06 Jul 2013 06:25:38 GMT

See help on Set Analysis.

spividori — Sat, 06 Jul 2013 12:05:25 GMT

Hi Lucian.

You can see it in my real data works poorly.

For example, I select May-2013 and sees as follows:

Attached is an example with my real data. Regards.

spividori — Sat, 06 Jul 2013 12:36:45 GMT

HI.

Already solved, thank you very much.

Sum({1< >} aggr( if((min({1< >} Total <Vta_Cli> Vta_Fecha)) = min(Vta_Fecha),1,0), Vta_año, Vta_mes, Vta_Cli))

Regards.

jose123456 — Fri, 03 Jan 2014 19:12:17 GMT

hola necesito hacer esto para qilkview

la idea es presionae año 2013 mes enero y el ptro mes mayor al siguiente

SELECT distinct NOMBRE

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

where fecha >='2013-01-01' and fecha <='2013-01-31'

and NOMBRE not in(select distinct NOMBRE FROM [FRONT].[dbo].[131 AUDITORIA FONDO] where

FECHA <='2012-12-31')