Percentages for a crosstable

lfalmoguera — Sun, 27 Feb 2011 15:18:19 GMT

Hi all,

let me first thank you in advance.

I am facing a little problem trying to show data in a percentage way.

I have uploaded the example I am working with.

I have a crosstable with information related to countries, products and month.

The first graph is easy to made. I show the current values for every combination. But the second graph is the one I cannot make it work. I need every column to be related to 100%. For instance, for April 09 I have Data values, and I need to obtain Data %. And so on for every month/country.

Country	Date_ok	Product	Data	Data %
FR	01/04/2009	A	37.9132	36.2%
FR	01/04/2009	B	32.4600	31.0%
FR	01/04/2009	C	34.3835	32.8%

GE	01/04/2009	A	39.8887	36.1%
GE	01/04/2009	B	48.0551	43.5%
GE	01/04/2009	C	22.4103	20.3%

IT	01/04/2009	A	20.3482	30.2%
IT	01/04/2009	B	25.8234	38.3%
IT	01/04/2009	C	21.3006	31.6%

SP	01/04/2009	A	49.5168	41.5%
SP	01/04/2009	B	39.2371	32.9%
SP	01/04/2009	C	30.6749	25.7%

UK	01/04/2009	A	35.4461	29.7%
UK	01/04/2009	B	49.2543	41.3%
UK	01/04/2009	C	34.4493	28.9%

Thanks a lot.

Percentages for a crosstable

prieper — Sun, 27 Feb 2011 18:42:36 GMT

You need to "tell" QlikView, over which dimensions you wish to have the aggregation, thus expression may look like

=sum(Data)/sum(total <Country> Data)

See the attached - have removed the month from the dimension.

HTH
Peter

Percentages for a crosstable

lfalmoguera — Mon, 28 Feb 2011 19:09:18 GMT

Thank you so much for the help!

It worked perfectly!

topic Percentages for a crosstable in QlikView

Percentages for a crosstable

Percentages for a crosstable

Percentages for a crosstable