topic Stack graph problem in QlikView

Stack graph problem

Mon, 05 Jul 2010 08:36:15 GMT

Hi,

I am using a Stack Graph.

The Dimensions are

My objective is to show the Market Share of each company for a particular month.

I am using the following expression :

sum(sales)/sum(total sales).

However this does not gives me the desired result as every month is not 100% but some other percentage of the total(e.g 13%)

Even the following Expression does not seems to be working :

sum(sales)/sum(total <Month> sales).

Please let me know if you need more information.

Regards,

Rohit

Mon, 05 Jul 2010 23:56:39 GMT

My guess, from what you're describing, is that you've got the 'relative' check-box selected for the expression on the expressions tab.

Uncheck it, and the world will go back to normal.

rwunderlich — Tue, 06 Jul 2010 00:56:52 GMT

sum(sales)/sum(total <Month> sales

works for me, with, as Ryan suggested, relative unchecked. Check "show in percent" in Numbers tab to get display in %.

-Rob