Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Week Measure

Trying to create a measure that will, based on whatever date, retrieve the prior weeks total.  Basically table should look like following:

Date     Week     Value

9/15     1              Week 0 Total

9/16     1              Week 0 Total

9/17     2              Week 1 Total

9/18     2              Week 1 Total... so on...

I am aware that week numbers are incorrect, just trying to provide an example of what I am trying to create.  I have an expression, but it does not correctly display data, rather weeks are rolling.

Any help is appreciated, thanks in advance for any help.