I'm trying to make a chart of sales by product

[#1]

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?

Thanks!

[jagan]

HI,

Try Scatter chart like below

Dimensions: Month, Product

Expression:

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.

Regards,

jagan.

[#3]

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

[Anonymous]

check this, helpful for you?

http://www.qlik.com/en-US-sense-gettingstarted

New to Qlik Sense Videos

[jagan]

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.

Hope this helps you.

Regards,

jagan.