topic Re: Calculate Sum For Last 7 Days in App Development

Calculate Sum For Last 7 Days

EvanBarrick — Tue, 26 Feb 2019 19:02:03 GMT

My data file is an on-going data file that is updated every seven days with the most recent week of data.

I want to display a basic chart for which the dimension would be the most recent ## of days. What would the most straight-forward way of doing this be?

Re: Calculate Sum For Last 7 Days

m_perreault — Tue, 26 Feb 2019 20:06:21 GMT

You can use Set Analysis

https://www.google.com/search?q=set+analysis+qlik+sense&rlz=1C1CAFA_enUS794US794&oq=set+analysis+qlik&aqs=chrome.0.0j69i60j69i65l2j69i57j0.2023j0j7&sourceid=chrome&ie=UTF-8

For your measure in your chart do something like

Sum({<[DateField] = {">=$(Today()-7)"}>}Value)