Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Vitali
New Contributor III

Running Total with filters. Newbie Question.

Hey there everyone,

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.

Any help would be appreciated.

 

Thanks in advance!

4 Replies
Partner
Partner

Re: Running Total with filters. Newbie Question.

Can u please share a screen shot of what u have without zooming and what happens when u zoom?

I'd like to build an image of wht u aim to do before answering; to see if it's really a cumulative sum that u're doing, a sum etc

Thanks

Vitali
New Contributor III

Re: Running Total with filters. Newbie Question.

Hi Omar, 

I think my initial description of the issue is slightly misleading - the problem is not when I zoom but rather, when I filter to a shorter period. 

Perhaps its a whole different approach that I should employ, a set analysis for example.. I don't know for sure.

Partner
Partner

Re: Running Total with filters. Newbie Question.

zoom in my sentence meant filter ..

Still can't help u without understanding ur situation.

Vitali
New Contributor III

Re: Running Total with filters. Newbie Question.

Posted the question again, with much more details: https://community.qlik.com/t5/New-to-Qlik-Sense/Running-Total-with-all-periods/m-p/1569783#M132858

I'll delete this post later on today.