topic Re: delete a record based on certain calendar date in QlikView

delete a record based on certain calendar date

qvqfqlik — Mon, 04 Jul 2016 21:24:24 GMT

How to drop a record for a certain calendar date. Please help

Re: delete a record based on certain calendar date

arasantorule — Tue, 05 Jul 2016 03:30:37 GMT

Hi,

You can just load the data excluding that particular date.

If your requirement is different, can you explain in detail.

Thanks.

Re: delete a record based on certain calendar date

ajsjoshua — Tue, 05 Jul 2016 04:38:50 GMT

Hi ,

In script or in set analysis you can achieve your requirement

share some sample.

Regards,

Joshua.

Re: delete a record based on certain calendar date

muthukumar77 — Tue, 05 Jul 2016 04:55:32 GMT

Hi,

Can you share the sample app?

Re: delete a record based on certain calendar date

anagharao — Tue, 05 Jul 2016 05:14:17 GMT

Hi,

You could use script level clause:

LOAD DATE(Date,'DD/MM/YYYY') as [Date],

Amount

FROM

.\DropDate.xlsx

(ooxml, embedded labels, table is Sheet1)

where DATE(Date,'DD/MM/YYYY') <> '01/01/2016';

Regards,

Anagha

Re: delete a record based on certain calendar date

qvqfqlik — Tue, 05 Jul 2016 22:55:22 GMT

Thanks all !. I already fixed it.

Whenever I post, it needs moderator approval - which stuckup my work

Re: delete a record based on certain calendar date

oknotsen — Wed, 06 Jul 2016 08:09:20 GMT

That moderator approval has to do with you spamming a lot in your first few posts, spamming other topics with redirects to your (other) topics and stuff like that.

Act normal and that moderator approval will go away.

Topic locked.