Condition problem

javier1070 — Wed, 25 Nov 2020 16:16:04 GMT

Good afternoon

I need to collaborate with the following segmentation in qlikview, I did it in excel but there is still no way the expression in the script in qlikview

condition

$desc_genero$ IN ("VACIO") AND $desc_genero$ IN ("VACIO", "DESCGENERORow0") AND $VLR_RECAUDO$ <= 40234.15482708782 as Segmento 1

$desc_genero$ IN ("DESCGENERORow4", "DESCGENERORow2", "DESCGENERORow3", "DESCGENERORow0", "DESCGENERORow1") AND $desc_genero$ IN ("VACIO", "DESCGENERORow0") AND $VLR_RECAUDO$ <= 40234.15482708782 as Segmento2

$desc_genero$ IN ("DESCGENERORow4", "DESCGENERORow2", "DESCGENERORow3", "DESCGENERORow1") AND $VLR_RECAUDO$ <= 40234.15482708782 as Segmento3

$VLR_RECAUDO$ > 40234.15482708782 AND TRUE as Segmento4

The script is as follows:

LOAD ID,

NOM_RAMO_CON,

NOM_PRODUCTO,

NOM_CANAL,

NOM_SUC_NEG,

NOM_CLA_POLIZA,

ECOM_AGEN_NOMBRE,

TIP_NEG,

FOR_PAGO,

VLR_PRIMA,

VLR_ASEGURADO,

VLR_RECAUDO

FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

PNJ:

LOAD ID,

direccion_trabajo,

desc_ciudad_trabajo,

telefono_trabajo,

desc_act_economica,

desc_sector_economico,

desc_rang_ingresos,

desc_rang_egresos,

desc_rang_activos,

desc_rang_pasivos,

exrc_fecha_act_financiera,

[TIPO PERSONA],

exrc_fecha_nacim,

desc_ciudad_nacim,

direccion_resid,

desc_ciudad_resid,

telefono_residencia,

desc_profesion,

desc_vinc_laboral,

desc_ocupacion,

exrc_desc_nacionalidad,

desc_genero

FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

AGE_TABLE:

LOAD*,

Age(Today(),exrc_fecha_nacim) AS Age,

IF(desc_genero=("VACIO") AND desc_genero=("VACIO", "DESCGENERORow0") AND VLR_RECAUDO <= ('40234.15482708782') as Segmento1

Resident PNJ;

DROP Table PNJ;

Re: Condition problem

Peter_Cammaert — Mon, 13 Mar 2017 16:13:53 GMT

I can only help you with part of the load statement (which only tries to decide on the value of Segmento1).

Is 40234.15482708782 a datetime value? If so, then you can write these conditions as follows:

IF ((desc_genero = 'VACIO') AND

Match(desc_genero, 'VACIO', 'DESCGENERORow0') AND

(VLR_RECAUDO <= '25/02/2010 3:42:57'), true(), false()) AS Segmento1,

The others follow the same expression template.

topic Re: Condition problem in QlikView

Condition problem

Re: Condition problem