topic Re: in clause in Qlickview -> match function? in QlikView

in clause in Qlickview -> match function?

Anonymous — Mon, 18 May 2015 15:37:14 GMT

Hi,

I want to know how can I male a IN clause (typical SQL) in Qlicjkiew. Do I have to use match function?

LOAD fecha,

(Date(monthstart(fecha), 'MMM-YY')) as periodo,

WeekDay(fecha) as dia_semana,

ciudad,

pais,

cliente,

producto,

venta,

margen,

if (producto in ('P1', 'P2'), 'T1', 'T2') as tipo_producto,

tipo_servicio,

canal

FROM

(ooxml, embedded labels, table is detalle_ventas_canal_margen);

Thanks in advance,

Anonymous — Mon, 18 May 2015 15:46:29 GMT

Try :

if ( match ( producto , 'P1', 'P2' ) , 'T1', 'T2' ) as tipo_producto,

buzzy996 — Mon, 18 May 2015 15:54:14 GMT

u can also try, if ( wildmatch ( producto , 'P1', 'P2' ) , 'T1', 'T2' ) as tipo_producto,

Mon, 18 May 2015 15:56:07 GMT

Following post might be helpful

shambhub — Mon, 18 May 2015 16:20:52 GMT

Hi Jaun,

You can use below expression

if (producto mixmatch ('P1', 'P2'), 'T1', 'T2') as tipo_producto

Best Regards

Shambhu B