topic Removing Saturday,Sunday in QlikView

Removing Saturday,Sunday

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

Hi Experts,

I am Getting Daily Qvd's from this Script, but how can i exclude Saturday,Sunday

T1:

LOAD Date,

Date(Date,'DDMMM') as Day,

Product,

Sales

FROM

(ooxml, embedded labels, table is Sheet1);

let vm=NoOfRows('T2');

for i=0 to $(vm)-1;

let vFileName=peek('Day',$(i),'T2');

NoConcatenate

T2:

load *

Resident T1 where Day='$(vFileName)';

STORE T2 into D:\ Requirements\MyDAILY QVDS\Day&Month\Month\$(vFileName).qvd (qvd);

DROP table T2;

next i;

Note:- i need to remove Saturday,Sunday here.

Regards,

Mahesh

Re: Removing Saturday,Sunday

effinty2112 — Wed, 31 Aug 2016 18:35:06 GMT

Hi Mahesh,

Try this:

T1:

LOAD Date,

Date(Date,'DDMMM') as Day,

Product,

Sales

FROM

(ooxml, embedded labels, table is Sheet1) Where Not Match(WeekDay(Date),'Sat', 'Sun');

cheers

Andrew

Re: Removing Saturday,Sunday

jayanttibhe — Wed, 31 Aug 2016 18:42:54 GMT

Andrew's solution should work.

Just try MixMatch if you don't want Case Sensitive dependency.

As:

T1:

LOAD Date,

Date(Date,'DDMMM') as Day,

Product,

Sales

FROM

(ooxml, embedded labels, table is Sheet1) Where Not MixMatch(WeekDay(Date),'Sat', 'Sun');

cheers

Re: Removing Saturday,Sunday

qlikview979 — Wed, 31 Aug 2016 19:01:25 GMT

Hi All,

Thanks for Your help

Regards,

Mahesh