topic Re: Displaying Previous Weeks in Straight Table in QlikView

Displaying Previous Weeks in Straight Table

AC — Sat, 16 Nov 2024 04:28:31 GMT

Hello,

I have created a week over week straight table with required fields, week as dimension and some expressions.

What i am looking is, this straight table should update dynamically each day (Monday to Friday) like below.

As of today the table is showing weeks like 12/31, 1/7, 1/14, 1/21, 1/28, 2/4 and 2/11.

If I open the dashboard tomorrow (2/12), then the table should update the weeks to 1/1, 1/8, 1/15, 1/22, 1/29, 2/5, 2/12 with the respective counts and on 2/13 the table should show like 1/2, 1/9.......2/13.

Re: Displaying Previous Weeks in Straight Table

rahulpawarb — Mon, 18 Feb 2019 09:52:50 GMT

Could you please share the sample data/application? This will help me to understand and provide my inputs.

- Rahul

Re: Displaying Previous Weeks in Straight Table

AC — Mon, 18 Feb 2019 16:12:12 GMT

Rahul,

I have uploaded the qvw file in my original post. Please see.

Regards,