topic Select only week ending dates in QlikView

Select only week ending dates

Tue, 10 Dec 2013 10:23:27 GMT

Hi,

I have a date dimension from which i want to only select the Friday dates? Can someone give me an expression to do this?

I.e. I have the following:

I need:

thanks

Tue, 10 Dec 2013 10:30:06 GMT

use the Weekday() function.

Fridays:

LOAD Date

FROM

FROM [..\dates.qvd] (qvd)

Where Weekday(Date)=5;

Hope this helps

MayilVahanan — Tue, 10 Dec 2013 10:39:31 GMT

Try like this

Load

If(WeekDay(Date)='Fri', 1, 0) AS Flag,

From Tablename;

In Expression, try like this

=Sum({<Flag = {1}>} Sales)

Tue, 10 Dec 2013 11:01:46 GMT

PFA hope this will help you