topic Re: To pick data after a specific date! in QlikView

To pick data after a specific date!

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

Hi, Dear

Sample data shown here are some transaction taken place in July.(CR_DATE), If I am to chose data of which from date falls after 10th March, how this will be done in the script,Thereby If I can create after & before cut off date (10th March) I may be able to separate data from that cut of date. script too attached for your reference!

REFUNDS:

LOAD

BRANCH,

CLASS_CODE,

PRODUCT_CODE,

POLICY_NO,

NAME_OF_INSURED,

CREDIT_NOTE_NO,

CREDIT_NOTE_DATE,

DATE(CREDIT_NOTE_DATE)AS CR_DATE,

PERIOD_FROM,

DATE( PERIOD_FROM) AS FROM_DATE,

PERIOD_TO,

PREMIUM,

ADDRES,

REASON,

FINANCIAL_INTEREST,

ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$);

Thanks

Neville

Re: To pick data after a specific date!

vkish16161 — Tue, 17 Oct 2017 15:38:35 GMT

Neville,

Something like this:

REFUNDS:

LOAD

BRANCH,

CLASS_CODE,

PRODUCT_CODE,

POLICY_NO,

NAME_OF_INSURED,

CREDIT_NOTE_NO,

CREDIT_NOTE_DATE,

DATE(CREDIT_NOTE_DATE)AS CR_DATE,

PERIOD_FROM,

DATE( PERIOD_FROM) AS FROM_DATE,

PERIOD_TO,

PREMIUM,

ADDRES,

REASON,

FINANCIAL_INTEREST,

ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$)

where CR_DATE > 03/01/2017;

Re: To pick data after a specific date!

Anil_Babu_Samineni — Tue, 17 Oct 2017 15:39:56 GMT

Do you mean this?

REFUNDS:

LOAD

BRANCH,

CLASS_CODE,

PRODUCT_CODE,

POLICY_NO,

NAME_OF_INSURED,

CREDIT_NOTE_NO,

CREDIT_NOTE_DATE,

DATE(CREDIT_NOTE_DATE) AS CR_DATE,

PERIOD_FROM,

DATE( PERIOD_FROM) AS FROM_DATE,

PERIOD_TO,

PREMIUM,

ADDRES,

REASON,

FINANCIAL_INTEREST,

ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$) FROM DATE(CREDIT_NOTE_DATE) = '3/10/2017';

Re: To pick data after a specific date!

nevilledhamsiri — Tue, 17 Oct 2017 16:36:55 GMT

Dear Vishnu,Anil,

Thanks a lot your suggestions work! Suppose I join a separate file which carries credit_note_number which field is already there in the file already loaded. If I am to say Credit_note_number in the first file equals to Credit_note_number in the 2nd file to be dropped (excluded) & only to appear others how it could be done! Then my conditions are

1_ Seect only cases where period_from date >07/0/2017 which is already achieved as you suggested.

2_ excludes cases where credit_note_numbers are the same

Thanks

Neville.

REFUNDS:

LOAD

BRANCH,

CLASS_CODE,

PRODUCT_CODE,

POLICY_NO,

NAME_OF_INSURED,

CREDIT_NOTE_NO,

CREDIT_NOTE_DATE,

PERIOD_FROM,

PERIOD_TO,

PREMIUM,

ADDRES,

REASON,

FINANCIAL_INTEREST,

ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$)

WHERE PERIOD_FROM >'7/10/2017';

POL:

LOAD CREDIT_NOTE_NO

FROM (ooxml, embedded labels, table is Sheet2);

Re: To pick data after a specific date!

nevilledhamsiri — Wed, 18 Oct 2017 17:47:53 GMT

Dear qlikers!

Thanks for your help!

Eventually I was able to achieve my output! Forward the same for your reference!