first post ever. I'm an advanced Power BI user that has recently migrated to Qlik Sense - I love it but I'm still struggling with some bits and pieces.
Now, here's my case: I have a running total as a measure for a line chart. The full ranges of dates is for about 3 years - two years in the past and 1 in the future. Now, without zooming, the results seem fine. However, if I filter to a period of week or two, the calculation reflects that shorter period so I receive an incorrect amount. I'd like be able to look at any time window while keeping all the cumulative change until the starting point.
I suspect I may need to use a master calendar to get what I'm aiming for, currently I'm only using the source table date column.