topic Re: Segment customers in levels in QlikView

Segment customers in levels

ecolomer — Sat, 07 Nov 2015 15:40:34 GMT

I have an table with sales to customers and the area where the sale occurs.

There are customers who may be in more than one area.

Levels: T1 and T2 are defined by user

I would analyze those sales by three levels:

- Customers in an area whose sales are less than a user-defined value (T1)

- Customers whose sales are between T1 and T2

- Customers whose sales are higher than T2

For each tranche would like to know the number of customers, sales, average selling each zone.

Attached basic example with Excel file and QV

Thank's in advance

swuehl — Sat, 07 Nov 2015 16:23:54 GMT

Maybe like attached?

ecolomer — Sat, 07 Nov 2015 16:36:54 GMT

Thank's, but I can't touche the script

Any idea?

maxgro — Sat, 07 Nov 2015 16:39:50 GMT

maybe, for T1

Count(distinct if(aggr(sum(Venta), Cliente,Zona)<$(T1), Cliente))

sum(if(aggr(sum(Venta), Cliente,Zona)<$(T1), Venta))

swuehl — Sat, 07 Nov 2015 16:47:05 GMT

Similar idea like maxgro.

Count( DISTINCT Aggr( if(Sum(Venta)<$(T1), Cliente), Zona, Cliente))

Sum( Aggr( if(Sum(Venta)<$(T1), Sum(Venta)), Zona, Cliente))

Latter should also work with more than one Venta record per Cliente and Zona.

ecolomer — Sat, 07 Nov 2015 17:03:15 GMT

Thank's

ecolomer — Sat, 07 Nov 2015 17:04:11 GMT

Thank's