Display only the last full weeks data

[#1]

Hi,

I have a dataset as below:

Weekending	Count	Employee
10/05/2015	5	Joe
10/05/2015	7	Jack
03/05/2015	2	Joe

I want to produce a gragh with employees along the bottom by count. However I only want it to show the lastest week ending (in this case 10/05/2015.

Where would I put the expression and which expression.

Thank you in advance.

[sunny_talwar]

Try this: (PFA)

=Sum({<Weekending = {">=$(=WeekStart(Max(Weekending)))"}>}Count)

Update: Script used

SET DateFormat='DD/MM/YYYY'

Table:

LOAD Weekending,

     Count,

     Employee

FROM

[https://community.qlik.com/thread/164201]

(html, codepage is 1252, embedded labels, table is @1);

[#3]

Hi,

create a graph with employee ,weekending as dimension -

-where in dimension weekending use calculated dimension as max(Weekending)

count as expression

Thanks,

Khushboo

[#4]

Thank you.

i tried it, but nothing changed;