topic Previous Data in QlikView

Previous Data

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Previous Data

smilingjohn — Mon, 17 Feb 2020 09:09:59 GMT

Hi Expertise any update on this ?

Re: Previous Data

sergio0592 — Mon, 17 Feb 2020 16:15:20 GMT

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)

Re: Previous Data

smilingjohn — Wed, 19 Feb 2020 04:42:57 GMT

Thanks for the reply Sergio0592

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

Thanks

Re: Previous Data

Brett_Bleess — Wed, 11 Mar 2020 19:41:09 GMT

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

Regards,
Brett