# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor III

## straight table : total of expression doesn't work

hi every body,

I can't understand why total of expression doesn't work in this straight table :

i should have 28,22 % witch is : 2721107 / 9640719 .

see attached file,

thank you very much for your help

Arnault

1 Solution

Accepted Solutions
MVP

## Re: straight table : total of expression doesn't work

try this expression, you will get it what you want

sum(aggr((sum(surface)*sum(tirage2)),editionsec))/sum(aggr((sum(pag2)*sum(tirage2)),editionsec))

14 Replies
Valued Contributor II

## Re: straight table : total of expression doesn't work

New Contributor III

## Re: straight table : total of expression doesn't work

thank you but i don't want the average of lines witch is 28,146%

but

2721107 / 9640719 .witch is 28,225 %

A.

Honored Contributor

## Re: straight table : total of expression doesn't work

Hi,

You'd be as well to replace Column(5)/Column(3) with the actual expressions and the summary should work. This column(number) business is all very well but if new columns are inserted or columns moved it can all turn sour.

cheers

Andrew

Honored Contributor III

## Re: straight table : total of expression doesn't work

PFA...

New Contributor III

## Re: straight table : total of expression doesn't work

hi andrew,

New Contributor III

## Re: straight table : total of expression doesn't work

sorry but  i don't want the average of lines witch is 28,146%

but

2721107 / 9640719 .witch is 28,225 %

A.

Valued Contributor II

## Re: straight table : total of expression doesn't work

but the denominator is 9640716 and nor 9640719 Please check

Honored Contributor

## Re: straight table : total of expression doesn't work

Hi

sum(surface)*(tirage2)/sum(pag2)*sum(tirage2))

doesn't look quite right.

Maybe:

sum(surface*tirage2)/sum(pag2*tirage2))

or

sum(surface) * sum(tirage2) / (sum(pag2) * sum(tirage2)))

Good Luck

Andrew

New Contributor III

## Re: straight table : total of expression doesn't work

yes 9640716 but it still makes 28.225 %