Re: How to generate a Whale Curve and Cumulative Profit graph from unsorted raw sales data
I wish my new book QlikView Your Business was already out!!! It's coming out in April. In the book, I am giving very detailed step-by-step instructions on building the Whale Tail chart. You'll get to build one as part of the tutorial.
Assuming that you don't want to wait till April to buy the book, let me give you some abbreviated instructions here:
Chart Type: Scatter Chart.
X-Axis Expression: Cumulative Sales = Sum(Sales), using Full Accumulation.
Y-Axis Expression: Cumulative Profit Amount = sum(Profit), using Full Accumulation