Percentages for a crosstable

[lfalmoguera]

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.

[prieper]

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

[lfalmoguera]

Thank you so much for the help!

It worked perfectly!