Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Khalid.
What you mean of Segmentation?
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.
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.
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
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
//-- 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