topic Re: Complete Week in QlikView

Complete Week

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

I have the data as below format , date associated with a week , i need to show data for rolling past 4 weeks , so if i consider today() - 30 then i am showing data for only a part of the week ... how do i make sure that i get data for complete week ?

example in the below data i am seeing only 1 day in W3 instead i want all days in w3 week

here is my current expression:

=count({OpenDate= {">=$(=Date(today()-30))"},Type ={'TS'}>} DISTINCT(CaseNumber))

03/18/2018	W7
03/17/2018	W7
03/16/2018	W7
03/15/2018	W7
03/14/2018	W7
03/13/2018	W7
03/12/2018	W7
03/11/2018	W6
03/10/2018	W6
03/09/2018	W6
03/08/2018	W6
03/07/2018	W6
03/06/2018	W6
03/05/2018	W6
03/04/2018	W5
03/03/2018	W5
03/02/2018	W5
03/01/2018	W5
02/28/2018	W5
02/27/2018	W5
02/26/2018	W5
02/25/2018	W4
02/24/2018	W4
02/23/2018	W4
02/22/2018	W4
02/21/2018	W4
02/20/2018	W4
02/19/2018	W4
02/18/2018	W3

Re: Complete Week

Digvijay_Singh — Tue, 20 Mar 2018 23:59:18 GMT

May be Weekstart can help -

=count({OpenDate= {">=$(=Weekstart(Date(today()-30)))"},Type ={'TS'}>} DISTINCT(CaseNumber))

Re: Complete Week

Siva_Sankar — Wed, 21 Mar 2018 01:35:35 GMT

Hi Steve,

You may use something like below using weekstart function or the attached approach.

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -14))<=$(=Date(Max(Date)))’}>} Sales )

Find the attached qvw.

-Siva

Re: Complete Week

stevejones1 — Wed, 21 Mar 2018 19:28:44 GMT

Please take a look at my file , i am using 1 in my expression(To avoid other selections) .. i want to show past 5 weeks only , and other selections made should NOT effect this chart.

But here when i select other filter values the charts keep changing .. please help!

Re: Complete Week

stevejones1 — Thu, 22 Mar 2018 20:17:50 GMT

Any help on this?