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

[kaushiknsolanki · Accepted solution]

HI,

Please find the solution

Regards,

Kaushik Solanki

[qlikview979]

Thanks Bro,

Exact Output

Regards,

Mahesh

[qlikview979]

Hi All,

Thanks for your Support

Regards