Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

AC
New Contributor II

Updating weeks dynamically in Straight table

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.

 

Please find the attached qvw as well.

 

Thanks,

AC

    

 

2 Replies
bharathadde
Contributor

Re: Updating weeks dynamically in Straight table

Use following on dimension

=Date(WeekStart(ReadDate)+Num(Weekday(today())))

AC
New Contributor II

Re: Updating weeks dynamically in Straight table

Nope, Its not working