Everyone loves cumulative values on a chart and they’re are possible with an expression using the above function.
This shows you how to add them to the data table in your script!
Useful for this but also the idea can be used to solve other problems. For example recently I had a client where actions where timestamped but they needed to know the duration between the two actions. The data couldn’t be joined so this technique was used.
Uses for this way of working with data within Qlik comes up time and time again when developing!!!
Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!
Hope you all find it useful and I look forward to hearing your comments and if you have any tricks and tips like this you’d like to share.
Subscribers : Thanks for subscribing to my channel and I’d like to encourage you to visit my blog where I provide more Qlik related content.