topic Re: Display only the last full weeks data in QlikView

Display only the last full weeks data

Fri, 15 May 2015 13:33:53 GMT

Hi,

I have a dataset as below:

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 — Fri, 15 May 2015 13:39:42 GMT

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);

Fri, 15 May 2015 13:40:30 GMT

Hi,

create a graph with employee ,weekending as dimension -

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

count as expression

Thanks,

Khushboo

Fri, 15 May 2015 14:13:16 GMT

Thank you.

i tried it, but nothing changed;