Use different field for same selection

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Hi All,

i have a date field as sess_start_dt. it is coming from A Query which is used in 4 different table. i have used Qualify keyword to change the field name so that it can work with 4 different table. but at front end i want a date filter and table name filter, which will give show data of particular field for particular data. but when i am using date filter other 3 tables are disabled. please suggest.

my script look like this:

ABCTable:

load * inline

Landing

Base

Base1

CSDI

];

FinalTable:

LOAD sess_modul,

date(Floor(sess_start_dt),'MM/DD/YYYY'),

sess_end_dt,

duration,

status,

('Landing') as A

FROM \\na1.ofc.loc\dfsusa\HomeDir\Z922826\Home\Data\My Documents\CSDI\jobstats.qvd (qvd)

where left(sess_modul,11)= 'Job_CAN_NAZ' or Left(sess_modul,11)= 'Job_CAN_RSD'

or Left (sess_modul,11)= 'Job_CAN_LED' or left (sess_modul,16)= 'Job_RSDtoSTG_OUT';

QUALIFY *;

UNQUALIFY A;

FinalTable1:

LOAD sess_modul,

date(Floor(sess_start_dt),'MM/DD/YYYY'),

sess_end_dt,

duration,

status,

'Base' as A

FROM \\na1.ofc.loc\dfsusa\HomeDir\Z922826\Home\Data\My Documents\CSDI\jobstats.qvd (qvd)

where left (sess_modul,7)= 'Job_MAP' or Left(sess_modul,11)= 'Job_bi_item'

or Left (sess_modul,7)= 'Job_Ref' or left (sess_modul,7)= 'Job_ref' or left(sess_modul,9)= 'CSDI_BRWR'

or left(sess_modul,11)= 'CSDI_PRCCLS' or left(sess_modul,6)= 'Job_Bi' or left(sess_modul,7)= 'Job_map'

or left(sess_modul,7)= 'Job_sls' or left(sess_modul,6)= 'Job_ct' or left(sess_modul,23)= 'Job_bcldb_licensee_list'

or left(sess_modul,23)= 'Job_bcldb_stock_MasFile';

QUALIFY *;

UNQUALIFY A;

FinalTable2:

LOAD sess_modul,

date(Floor(sess_start_dt),'MM/DD/YYYY'),

sess_end_dt,

duration,

status,

'Base1' as A

FROM \\na1.ofc.loc\dfsusa\HomeDir\Z922826\Home\Data\My Documents\CSDI\jobstats.qvd (qvd)

where left (sess_modul,7)= 'Job_rsd' or Left(sess_modul,7)= 'Job_fct'

or Left (sess_modul,8)= 'Job_terr' or left (sess_modul,7)= 'Job_sft' or left(sess_modul,8)= 'Job_csdi'

or left(sess_modul,21)= 'Job_ct_sales_TranFile' or left(sess_modul,11)= 'Job_pricing' or left(sess_modul,33)= 'Job_bcldb_licensee_sales_TranFile'

or left(sess_modul,30)= 'Job_bcldb_store_sales_TranFile' or left(sess_modul,31)= 'Job_bcldb_agency_sales_TranFile'

or left(sess_modul,31)= 'Job_bcldb_detail_sales_TranFile';

Qualify *;

unqualify A,

ENV,

sess_src_row_cnt,

sess_rej_row_cnt,

sess_susp_row_cnt,

sess_load_row_cnt;

FinalTable3:

LOAD ENV,

sess_modul,

date(Floor(sess_start_dt),'MM/DD/YYYY'),

sess_end_dt,

duration,

status,

sess_src_row_cnt,

sess_rej_row_cnt,

sess_susp_row_cnt,

sess_load_row_cnt,

'CSDI' as A

FROM \\na1.ofc.loc\dfsusa\HomeDir\Z922826\Home\Data\My Documents\CSDI\jobstats1.qvd (qvd);

unqualify A;

FinalTable4:

load

DATE1,

JOB_COUNT_1,

PRD_LND,

JOB_COUNT_2,

NPRD_LND,

JOB_COUNT_3,

PRD_BS,

JOB_COUNT_4,

NPRD_BS,

JOB_COUNT_5,

SAP_TRN,

JOB_COUNT_6,

CT_MSTR,

JOB_COUNT_7,

LDB_MSTR,

JOB_COUNT_8,

CT_TRN,

JOB_COUNT_9,

LDB_TRN,

JOB_COUNT_10,

PTC,

JOB_COUNT_11,

CONFORMED_PTC,

JOB_COUNT_12,

PTR,

JOB_COUNT_13,

CONFORMED_PTR,

JOB_COUNT_14,

RSD_LANDING,

JOB_COUNT_15,

RSD_BASE,

JOB_COUNT_16,

SF_BASE,

JOB_COUNT_17,

CSDI_VS_RSD,

JOB_COUNT_18,

RTD,

JOB_COUNT_19,

TM1_PPS

FROM \\na1.ofc.loc\dfsusa\HomeDir\Z922826\Home\Data\My Documents\CSDI\jobstats2.qvd (qvd);

drop Table ABCTable;

Re: Use different field for same selection

Gysbert_Wassenaar — Wed, 20 Dec 2017 10:32:04 GMT

Consider concatenating FinalTable, FinalTable1 and FinalTable2 into one table instead of creating three tables and qualifying most fields.

Re: Use different field for same selection

Anonymous — Thu, 21 Dec 2017 13:59:17 GMT

Hi Gysbert. thankx for responding.

I Tried that but in Front end i need 2 filters. one with Landing,Base, Base1 And CSDI and the other filter with Date. it is not working there properly.

topic Use different field for same selection in QlikView

Use different field for same selection

Re: Use different field for same selection

Re: Use different field for same selection