topic Set Analysis Question in QlikView

Set Analysis Question

Anonymous — Fri, 26 Jun 2015 01:30:11 GMT

I have sales person and month as dimensions and sales of Product_A and Product_B as measure. I want ultimately create a bar chart to display % of product sales per month see below

Can some one help?

Data in the table

and ultimately a bar chart like

Re: Set Analysis Question

Anonymous — Fri, 26 Jun 2015 01:50:27 GMT

See attached

Re: Set Analysis Question

Anonymous — Fri, 26 Jun 2015 02:04:47 GMT

Modified my solution after you added a picture

Re: Set Analysis Question

Anonymous — Fri, 26 Jun 2015 02:17:03 GMT

I have been doing same but get 100%in all

Re: Set Analysis Question

Anonymous — Fri, 26 Jun 2015 11:57:17 GMT

That means you're doing something differently. Try to compare carefully, or upload your app and I'll take a look when I have time.

Re: Set Analysis Question

punitpopli — Fri, 26 Jun 2015 12:36:42 GMT

Hi,

Try using something like this:

sum(sales)/Sum(TOTAL <MONTH> sales)