topic PLEASE HELP ME in QlikView

PLEASE HELP ME

Mon, 01 Feb 2016 09:17:54 GMT

IN THE ABOVE STATUS FIELD I NEED TO LOAD ONLY (ACTIVE,DISCONNECT,INACTIVE, RE CONNECTION) VALUES ONLY

THANKS

RAMU.

swuehl — Mon, 01 Feb 2016 09:20:11 GMT

LOAD STATUS

FROM YourTableSource

WHERE Match(STATUS, 'ACTIVE','DISCONNECT','INACTIVE', 'RE CONNECTION');

avinashelite — Mon, 01 Feb 2016 09:24:50 GMT

if your loading it from an SQL source than handel it in the SQL

like SELECT * from

table.name

where STATUS in ('ACTIVE','DISCONNECT','INACTIVE', 'RE CONNECTION')

if you want to handel it in QV then try like this,

LOAD *

from

table

where STATUS='ACTIVE' or STATUS='DISCONNECT' or STATUS='INACTIVE' or STATUS='RE CONNECTION';