Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Business case
We need to measure “ongoing subscriptions” count which is sum of previous day's ongoing subscriptions and current date subscriptions.
For day#1 Ongoing subscription is same as Subscription count.
Attached: payvia_Qlikview_Support_MockUp.qvw
Screenshot#1 Cumulative sum for the whole date range
Screenshot#2 Cumulative sum for the selected date range. Desired value is in highlighted color below which is calculated separately and added to the screenshot
Screenshot#3: Cumulative sum for the entire date range for the selected filter
Screenshot#4: Cumulative sum of the selected date range and the filter. Desired result is highlighted and added in the below screenshot.
I would greatly appreciate if someone can help me with this problem?
FYI... I tried other approached like
Thanks and I appreciate any help.
Has anyone gave a shot at this?
Try an AsOf table. See here for an explanation of that concept and attached example.