Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Condition Where

Buenas Tardes,

Necesito realizar ls siguiente instrucción IN o MATCH o un equivalente para realizar lo siguiente:

T_Nuevo:
LOAD OrdVta as t_orno,
t_sotp,
t_dqua,
(t_dqua*t_wght) as kilos
FROM F:\DATA\Cab_Det.qvd (qvd)

WHERE year(t_invd) > 2010
and t_cofc <> 'T05'
and t_ctyp mixmatch ('1','5','6','20','28','42','55','66','67','70','114','117','121','125','132') // Necesito seleccionar solo estos codigos

Como puedo hacerlo ya que con IN, (no existe), match (no funciona)...

Gracias por la ayuda.

Atte.

Víctor Yupa.

1 Reply
johnw
Champion III
Champion III

Maybe this?

T_Nuevo:
LOAD OrdVta as t_orno,
t_sotp,
t_dqua,
(t_dqua*t_wght) as kilos
FROM F:\DATA\Cab_Det.qvd (qvd)

WHERE year(t_invd) > 2010
and t_cofc <> 'T05'
and mixmatch(t_ctyp,'1','5','6','20','28','42','55','66'
,'67','70','114','117','121','125','132')