Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

doespirito
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 :

Capture.PNG

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

see attached file,

thank you very much for your help

Arnault

1 Solution

Accepted Solutions

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))


Capture.JPG

14 Replies
techvarun
Valued Contributor II

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

sample.PNG

doespirito
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.


effinty2112
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

prma7799
Honored Contributor III

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

PFA...

doespirito
New Contributor III

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

hi andrew,

it's what i made first, but no results for total expression too.

Capture3.PNG

doespirito
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.

techvarun
Valued Contributor II

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

but the denominator is 9640716 and nor 9640719 Please check

effinty2112
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

doespirito
New Contributor III

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

yes 9640716 but it still makes 28.225 %

Community Browser