Discussion board where members can get started with Qlik Sense.
What's would be the best approach for a chart to show sales by product by month against investment made by product?
any screenshots, models where I can take ideas?
Try Scatter chart like below
Dimensions: Month, Product
1. Sum(Investment) -- X Axis
2. Sum(Sales) -- Y Axis
3. Sum(Sales)/Sum(Investment) -- For bubble size, if bubble size is big then the return on investment is more
Hope this helps you.
Jagan I like your aproach,
my problem is with the products,
I have around 100 sku that I'm promoting, and when I try to see all the information at once it's confusing
check this, helpful for you?
New to Qlik Sense Videos
For this scenario this is the best chart. Or try using Straight table/Bar chart and sort it by descending order based on the Sum(Sales)/Sum(Investment) expression.
So that you can see best performing products on top and non performing products on bottom.