Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jalun3
Contributor
Contributor

Help - Cumulative Data and Bar Graph

To start I have a 13 week 90D Turnover with the general expression below. It pulls from view where it lists only those in the 90D window and calculates turnover for each corresponding trailing 13 weeks.

Sum({<RelativeWeek = {">-14<0"}>}[RetentionTerms.TermCount])

*52

/

Sum({<RelativeWeek = {">-14<0"}>}[RetentionHires.Base])

 

 

I need help creating a new graph showing a 13 week trend but now cumulative from the start of the data (in this case beginning of 2024) where each week layers onto the next with a cumulative effect. By the end the 761 total from 8/12 would be more like ~25,000 starting from week 1 of this year and 8/5 would show ~24,300. Same logic for the terms. This view would take out any recent noise.

jalun3_0-1724337352296.png

 

Labels (3)
0 Replies