Previous Data

[smilingjohn]

Hi All

how to bring the previous data point to current dates (maximum date) ?
I am showing weekly reports by tickets now my porblem is like
i have open tickets till 12the Feb (21 tickets) and currently the week running is 17 th feb .
Now i want to show the tickets of 12 Feb on 17th Feb . How do i achive this ?an somoone please help on this..?

In Dimension :

Week

Expression:
Count (Ticket)

Thanks in Advance

[smilingjohn]

Hi Expertise any update on this ?

[sergio0592]

Hi,

I Don't know what are your dimensions, but try with 

Count({<YEAR=, MONTH=, WEEK=, DATE={">=$(=Num(WeekStart(Max(DATE), -1))) <=$(=Num(WeekEnd(Max(DATE), -1))"}>} Tickets)

[smilingjohn]

Thanks for the reply Sergio0592 

But this is not working  pleasease find my qlikview file attachment .

Thanks 

[Brett_Bleess]

We see no attachment, just FYI, which may explain the lack of responses at this point.

Regards,
Brett