topic Re: Exclude sunday in QlikView

Exclude sunday

Anonymous — Wed, 11 May 2016 12:26:42 GMT

Hi ,

1) how can i calculated the data excluding only sunday's in a year .

2) how can i calculated the data excluding both saturday and sunday's in a year .

Thanks in advance

Re: Exclude sunday

Chanty4u — Wed, 11 May 2016 12:32:02 GMT

hi,

chk dis

Re: Exclude Sunday

How to exclude Saturday, Sunday & Public holiday?

Re: Exclude sunday

MK_QSL — Wed, 11 May 2016 12:32:38 GMT

1) Where you want to exclude... Front end or back end?

2) exclude means what here? You don't want to load those records or want to exclude them while doing some calculations?

Re: Exclude sunday

santiago_respane — Wed, 11 May 2016 12:44:19 GMT

Hi Anusha,

what do you mean by calculate? in the front end or in the loading script.

There are a lot of ways for achieving this using:

-networkdays

-weekday

-Etc

Please elaborate more in order to be able to help you.

Kind regards,

Re: Exclude sunday

PrashantSangle — Wed, 11 May 2016 12:50:45 GMT

Hi,

If you want to count no of days in year excluding sunday

then in script create flag to identify sunday

like if(wildmatch(Weekday(datefield),'Sunday'),'weekend','weekday') as flag

and in front end use

count({<flag={'weekday'}>}datefield)

2: If you want to exclude Saturday and Sunday both then use networkday()

Kind Regards

Re: Exclude sunday

avinashelite — Wed, 11 May 2016 12:58:54 GMT

1) how can i calculated the data excluding only sunday's in a year .

* You can create a flag in your master calendar for identifying the Sunday ..like

if(weekday(date_field)='Sun',1,0) as Sunday_flag, while doing the calculation using this flag to eliminate the Sunday values

2) how can i calculated the data excluding both saturday and sunday's in a year .

* you Networkingdays() function it will automatically eliminate the Saturday and Sunday

Re: Exclude sunday

Anonymous — Wed, 11 May 2016 13:00:20 GMT

Backend ..

Re: Exclude sunday

Anonymous — Wed, 11 May 2016 13:04:07 GMT

Hi,

in the script for Exclude Saturday and Sunday.

Load your data in a Temp table and at the end do this :

TBLFACT_TEMP:

noconcatenate LOAD *,

if(weekday(Date)>4,'X') as Weekend //This for identify Saturday and Sunday for only sunday put > 5

RESIDENT TBLFACT;

Drop Table TBLFACT;

TBLFACT:

noconcatenate LOAD *

RESIDENT TBLFACT_TEMP

where Weekend <> 'X';

DROP TABLE TBLFACT_TEMP

Regards,

Emilien

Re: Exclude sunday

Anonymous — Wed, 11 May 2016 15:02:27 GMT

Thanks...

Re: Exclude sunday

Anonymous — Wed, 11 May 2016 15:03:06 GMT

Thanks...

Re: Exclude sunday

avinashelite — Wed, 11 May 2016 15:50:51 GMT

if you have got the answer, mark the correct answer and helpful answers so that it will be helpful for other members who have similar question