Saturday & Sunday

[qlikview979]

Hi Experts,

I have data like this

ID	Customername	Date	Sales
1	A	01-01-2016	100
4	D	04-01-2016	400
5	E	05-01-2016	500
6	F	06-01-2016	600
7	G	07-01-2016	700
8	H	08-01-2016	800
11	k	11-01-2016	1100
12	l	12-01-2016	1200

in source i have excluded Saturday & Sunday dates, but i am getting Saturday & Sunday dates in variable 

i don't want Saturday & Sunday

Please check here 09-01-2016,10-01-2016 not in source ,but showing in variables

[#2]

use variables defination like mentioned below,

vMax:      =date(Max(Date))

vMax1:    =date(Max(Date,2))

vMax2:    =date(Max(Date,3))

vMax3:    =date(Max(Date,4))

thanks,

Abdul

[beck_bakytbek]

Hi Manesh,

try this:

let vStartDay = date('01/01/2010');
let vEndDate = date('31/12/2016');



for x = vStartDay to vEndDate

tempCalendar:
load $(x) as Date AutoGenerate(1);

next x

NoConcatenate

Working_Calendar:
Load Date, weekday(Date) as WeekDay, week(Date) as Week, Month(Date) as Month, Year(Date) as Year, floor(month(Date)/3)+1 as Qtr

resident tempCalendar

where WeekDay(Date) <> 'Sat' and WeekDay(Date) <> 'Sun';

drop table tempCalendar;

i hope that helps

beck

[kaushiknsolanki]

Hi,

Try using below max function.

For Max use =Max(DATE,1)

For Prev use = =Max(DATE,2)

For Prev 2 Days use = =Max(DATE,3)

like others...

Regards,

Kaushik Solanki

[qlikview979]

Hi Experts,

I am not getting please find the attached files.

Regards

[#6]

Hi Mahesh,

May be you can use NetworkDays function and you can search in our community, will get lot about this

[qlikview979]

Hi Harish,

I Want  in Excel  ,please check i have attached my files.

Regards

[qlikview979]

Hi,

I have marked dates, that are not my source,but i am getting

I don't want Saturday & Sunday Dates

[qlikview979]

Hi Kishore,

I tried  ,not get if u get please share the link

Regards

[qlikview979]

Hi Bro,

I tried not get,

Please check with my files,

i have attached my files

Regards

[#11]

Hi

Have a look at this and try to understand

NetWorkingDay with Saturday Half Day

https://community.qlik.com/message/142775#142775

Regards