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

[tamilarasu]

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').

[qlikview979]

Hi Bro,

I Tried like that it showing  like below

vMax:    =12-01-2016

vMax1:    =1

vMax2:    =2

vMax3:    =3

Regards

[HirisH_V7]

Hi,

What the logic your'e using in ,

vMax2

    &

vMax3

-Hirish

[qlikview979]

Hi Bro,

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

[qlikview979]

Hi ,

Vmax----> max data

Vmax---->  previous data

Vmax---->2  previous data

Vmax----> 3  previous data

i need

Exclude Saturday,Sunday dates.

[tamilarasu]

Seems you have entered wrong expression.

=Date(Max(Date),1)

Correct expression should be

=Date(Max(Date,1))

[qlikview979]

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

[qlikview979]

Hi Experts,

Can any one Help me

stalwar1‌swuehl‌kush141087‌avinashelite‌

Regards

[HirisH_V7]

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