topic Re: Saturday & Sunday in QlikView

Saturday & Sunday

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

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

Re: Saturday & Sunday

tamilarasu — Tue, 02 Aug 2016 06:42:22 GMT

Hi Mahesh,

Define your variable formula like below,

vMax: =Max(DateField)

vMax1: =Max(DateField,1)

vMax2: =Max(DateField,2)

vMax3: =Max(DateField,3)

If the result is number, add date function i.e =Date(Max(DateField),'DD-MM-YYYY').

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 06:45:29 GMT

Hi Bro,

I Tried like that it showing like below

vMax: =12-01-2016

vMax1: =1

vMax2: =2

vMax3: =3

Regards

Re: Saturday & Sunday

HirisH_V7 — Tue, 02 Aug 2016 06:47:56 GMT

Hi,

What the logic your'e using in ,

vMax2

vMax3

-Hirish

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 06:48:22 GMT

Hi Bro,

is it possible to write any condition here...... i marked there check once

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 06:50:31 GMT

Hi ,

Vmax----> max data

Vmax----> previous data

Vmax---->2 previous data

Vmax----> 3 previous data

i need

Exclude Saturday,Sunday dates.

Re: Saturday & Sunday

tamilarasu — Tue, 02 Aug 2016 06:52:02 GMT

Seems you have entered wrong expression.

=Date(Max(Date),1)

Correct expression should be

=Date(Max(Date,1))

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 06:58:22 GMT

Hi Bro,

I want Dynamically for Example

if i click on 07-01-2016

that is my max date

then

07-01-2016 previous

06-01-2016 second previous

05-01-2016 third previous

like this i need

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 07:11:13 GMT

Hi Experts,

Can any one Help me

stalwar1‌swuehl‌kush141087‌avinashelite‌

Regards

Re: Saturday & Sunday

HirisH_V7 — Tue, 02 Aug 2016 07:44:50 GMT

Hi,

May be like this , using your sample data,

Temp:

LOAD * ,

WeekDay(Date) as Day

INLINE [

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

13, m, 09/01/2016, 1100

14, n, 10/01/2016, 1200

];

NoConcatenate

Data:

Load *

Resident Temp where Day<>'Sat'and Day<>'Sun' ;

Drop table Temp;

At Front End,

Variable Expressions,

vMaxDate1=Date(Max(Date,2),'DD/MM/YYYY') ,

Follows Like this

PFA,

HTH,

Hirish

Re: Saturday & Sunday

Tue, 02 Aug 2016 07:53:03 GMT

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

Re: Saturday & Sunday

beck_bakytbek — Tue, 02 Aug 2016 08:00:07 GMT

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

Re: Saturday & Sunday

kaushiknsolanki — Tue, 02 Aug 2016 08:45:06 GMT

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

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 09:04:33 GMT

Hi Experts,

I am not getting please find the attached files.

Regards

Re: Saturday & Sunday

Tue, 02 Aug 2016 09:05:24 GMT

Hi Mahesh,

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

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 09:06:03 GMT

Hi Harish,

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

Regards

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 09:09:55 GMT

Hi,

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

I don't want Saturday & Sunday Dates

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 09:15:24 GMT

Hi Kishore,

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

Regards

Re: Saturday & Sunday

qlikview979 — Tue, 02 Aug 2016 09:17:44 GMT

Hi Bro,

I tried not get,

Please check with my files,

i have attached my files

Regards

Re: Saturday & Sunday

Tue, 02 Aug 2016 09:39:19 GMT

Have a look at this and try to understand

NetWorkingDay with Saturday Half Day

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

Regards