topic Segmentation in QlikView

Segmentation

Wed, 02 Jun 2010 12:12:14 GMT

Hi Guys,

Does some one has any PDF or Word file desceribing how to use Segmentation in QlikView, any file or help will highly be appreciated.

Thanks.

Khalid

Segmentation

sparur — Wed, 02 Jun 2010 12:40:19 GMT

Hello Khalid.

What you mean of Segmentation?

Segmentation

Wed, 02 Jun 2010 12:51:13 GMT

As we segment our customers like show me the customers who purchased in X Product >= 200000 , multiple conditions so it picks the IDs of those who match criteria.

Segmentation

fernandotoledo — Wed, 02 Jun 2010 12:58:39 GMT

The idea in qlikview is to work with fields and as you select you create the segmentation.

You can make selections on lists, charts (straight table) where you can search in a calculated expression and other objects.

You should search for the keywords "class" and "intervalmatch" too this functions classify numeric fields into segments, like age <10 years, between 10 and 20, 20 to 20, etc.

Hope it helps.

Segmentation

sparur — Wed, 02 Jun 2010 13:04:45 GMT

You can find a good example in QV Reference manual, part describes a Set Analysis.

sum( {$<Customer = {"=Sum({1<Year = {2007}>} Sales ) > 1000000"}>} Sales )

returns the sales for the current selection, but with a new
selection in the Customer field: only customers who during
2007 had a total sales of more than 1,000,000

Segmentation

Wed, 02 Jun 2010 15:02:07 GMT

Well abut Segmentation you must by use Set Analysis, if is Segmentation or Scoring that you need, the next lines perhaps help

Puntajes_Cliente:
LOAD
[Codigo Cliente],
if([Puntos Sueldo]+[Puntos Nivel Instruccion]+[Puntos Nivel Ocupacion]+[Puntos Ubigeo]> =0 and <=3.660533,'D',
if([Puntos Sueldo]+[Puntos Nivel Instruccion]+[Puntos Nivel Ocupacion]+[Puntos Ubigeo]> =3.660533 and <=7.321167,'C',
if([Puntos Sueldo]+[Puntos Nivel Instruccion]+[Puntos Nivel Ocupacion]+[Puntos Ubigeo]> =7.321167 and <=10.981800,'B2',
if([Puntos Sueldo]+[Puntos Nivel Instruccion]+[Puntos Nivel Ocupacion]+[Puntos Ubigeo]> =10.981800 and <=14.642433,'B1',
if([Puntos Sueldo]+[Puntos Nivel Instruccion]+[Puntos Nivel Ocupacion]+[Puntos Ubigeo]> =14.642433, 'A','NSE'))))) AS SegmentoCliente
FROM (qvd);
//-- Puntos Sueldo =
// if(SueldoRango=0 or isnull(SueldoRango),0, if(SueldoRango<600,0.10,if(SueldoRango>600 and SueldoRango<1299,0.40,if

//(SueldoRango>1300 and SueldoRango<2399,1.20,if(SueldoRango>2400 and SueldoRango<9499,3.20,5))))) as [Puntos Sueldo]

Regards

Christian Seijas