Qlik Community

Ask a Question

App Development

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

April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Week sum - previous week

Trying to use RangeSum function to sum sales values based on the weeknum function.  Basically, when I use this function, I would like the results to show value for last total week when used in table.


Date     Weeknum     New Measure

9/10:      5                    Total from Week Four

9/11:      5                    Total from Week Four

9/12:      6                    Total from Week Five

9/13:      6                    Total from Week Five...  etc

Is there any way to achieve something similar to this, maybe using different functions?  The expression I made did not produce proper values.  Any help is appreciated.

1 Reply
Creator II
Creator II

Can you share sample data?