How to calculate a ratio

[#1]

Hello everybody,  new using qlikview i cant find solution to my problem:

here a little description:

i have the follow cross table in Qlikview and i need to calculate column 5 (Ratio Sales / Chimical Activity Sales).

Country1	City	Sales	Chimical Activity Sales	Ratio Sales / Chimical Activity Sales
Irland	Dublin	100	80	100/980
Japan	Tokio	200	100	200/980
	Osaka	450	400	450/980
USA	NY	300	100	300/980
	Boston	500	300	500/980
TOTAL		1 550	980	1550/980

i was trying to use TOTAL fonction but is not working

Sum([Sales / sum(TOTAL  Chimical Activity Sales]

how could i do to fixe the denominator "980" ?...

Thanks

[miguelbraga]

Hi Teddy,

I think your expression is wrong:

What you have:

Sum([Sales / Sum (TOTAL Chimical Activity Sales]

What you should have:

Sum([Sales]) / Sum ([Chimical Activity Sales])

Enable totals in Country 1 and this should do the trick

Regards,

MB

[Anonymous]

if Chimical Activity Sales is fixed like 980

then you can try:

Sum([Sales])/980 in expression For Ratio

Then in number format you can set this expression with Ticked Show in % with 2 decimal

[Anonymous]

Also you can defined a variable with:

Ctrl+Alt+V

like VChemicalSales=980

then

Expression:  sum(Sales)/$(VChemicalSales)

Hope this will help!!

[Kushal_Chawda]

try,

sum(Sales)/ Sum( Total [Chimical Activity Sales])

[sauliusr]

You expression should be:

Sum([Sales]) / Sum (TOTAL [Chimical Activity Sales])

[#7]

Hi thanks but in my cross table

When I’m trying Sum([Sales]) / Sum ([Chimical Activity Sales])

or

Sum([Sales]) / Sum (TOTAL [Chimical Activity Sales])

He is giving to me for the first row (100/80), second row (200/100) and so on,

but the ratio that I need is 100/980 for the first row, 200/980 for second and so on.

In my exemple 980 is a calculated value is not fixed amount, is the total of column “Chimical Activity Sales”

Regards

Tedtris.

[#8]

Hi thanks but in my cross table

980 is a calculated value is not fixed amount, is the total of column “Chimical Activity Sales”

Regards

Tedtris.

[#9]

Hi thanks but  in my exemple 980 is a calculated value is not fixed amount, is the total of column “Chimical Activity Sales”.

Regards

Teddy

[#10]

Hi thanks but  in my exemple 980 is a calculated value is not fixed amount, is the total of column “Chimical Activity Sales”.

Regards

Tetris