topic Re: how to create link table when qualify and unqualify statements are used in QlikView

how to create link table when qualify and unqualify statements are used

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

og:
QUALIFY*;
UNQUALIFY oyear,omonth;
LOAD
BR_NAME,
CUSTOMER_NAME,
VC_GOLD_TYPE,
EX_TYPE,
VC_BILL_NO,
DT_BILL_DATE,
DT_YEAR as oyear,
DT_MON as omonth ,
VC_CATEGORY,
VC_ITEM_DET,
VC_ITEM_DESC,
VC_PURITY,
VC_TYPE,
VC_PRIMARY_UOM,
VC_ITEM_CODE,
NU_NANG,
NU_NANG_PCS,
NU_GROSS_WTT,
NU_NETT_WTT,
NU_CARRAT_WTT,
NU_RATE,
NU_OTHER_CHARGES,
NU_AMOUNT
FROM
[D:\DATA\QVD\XXTBZ_POSURD_CHECKLIST_V.qvd]
(qvd);

pm:
QUALIFY*;
UNQUALIFY omonth,oyear;
LOAD
BR_NAME,
VC_VOUCHER_NO,
DT_VOUCHER_DATE,
DT_MONTH as omonth,
DT_YEAR as oyear,
VC_REF_SALE_VOUCHER_NO,
DT_REF_SALE_VOUCHER_DATE,
VC_CATEGORY,
CATEGORY_DESCRIPTION,
CUSTOMER_NAME,
BR_CODE,
CH_PAY_MODE,
PAY_MODE_DESC,
TCS_AMOUNT,
TOTAL_BILL_AMOUNT
FROM
[D:\DATA\QVD\XXPOS_SALES_PAYMENT_V.qvd]
(qvd);

now how to create a link table for oyear and omonth

Re: how to create link table when qualify and unqualify statements are used

Claudiu_Anghelescu — Wed, 19 Jun 2019 04:41:50 GMT

You should unqualify the original fields not the aliases.

UNQUALIFY DT_YEAR, DT_MONTH;

Re: how to create link table when qualify and unqualify statements are used

jonathandienst — Wed, 19 Jun 2019 05:08:17 GMT

Which fields do you need in the link table? To reference the qualified fields, just add the prefix, like [og.BR_NAME] or [pm.BR_NAME]