Removing Saturday,Sunday

[qlikview979]

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

[effinty2112 · Accepted solution]

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

[jayanttibhe]

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

[qlikview979]

Hi All,

Thanks for Your help

Regards,

Mahesh