
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Price Volume Analysis visualized in Waterfall Chart
Hello Everyone,
I've got a nice-to-solve question regarding a price volume analysis I want to try to visualize in a waterfall chart.
So for example, the calculation for the price effect is as follows:
Price effect = (Price CY - Price PY) * Volume CY
Pretty easy and it does work, if I calculate the effects for different product groups in a straight table where I use the Totals function as sum:
It would be nice to visualize the different effects in a waterfall chart and here is where I ran into problems.
There are no dimensions in waterfall chart so nothing to sum up, therefore QS calculates the same way as on the product group level, i.e. Price effect = (Price CY - Price PY) * Volume CY. This generates a different result than on product group level (see also attached file):
Is there a way to calculate the same totals in Qlik Sense as in straight table with all dimensions, so I visualization in waterfall chart is possible?
If you need more context or information, let me know.
Kind regards
Stefan
- Subscribe by Topic:
-
Chart
-
dimension
-
expression
-
General Question
-
Set Analysis
-
Visualization
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sounds like you're looking for something along the lines of:
Sum(Aggr((Price CY - Price PY) * Volume CY,Product))
Or some other form of aggr().


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sounds like you're looking for something along the lines of:
Sum(Aggr((Price CY - Price PY) * Volume CY,Product))
Or some other form of aggr().

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Or,
that's what I've tried too, but with the wrong syntax. Thank you very much for your spot on reply!
Best regards
Stefan
