Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
Creator

Calculate Sum For Last 7 Days

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?

1 Solution

Accepted Solutions
m_perreault
Creator III
Creator III

You can use Set Analysis 

https://www.google.com/search?q=set+analysis+qlik+sense&rlz=1C1CAFA_enUS794US794&oq=set+analysis+qli...

 

For your measure in your chart do something like

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

View solution in original post

1 Reply
m_perreault
Creator III
Creator III

You can use Set Analysis 

https://www.google.com/search?q=set+analysis+qlik+sense&rlz=1C1CAFA_enUS794US794&oq=set+analysis+qli...

 

For your measure in your chart do something like

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