topic make a sum of table columns in QlikView

make a sum of table columns

Fri, 31 Dec 2010 15:12:23 GMT

hi, i make a sum of a table columns and this expression don't give me a good result

spividori — Fri, 31 Dec 2010 15:57:18 GMT

Hi.
I had the same problem and solved it by performing the calculations in the script.

If you do not understand up a excel values to give you an example.

Regards.

Sandro.

Fri, 31 Dec 2010 18:54:22 GMT

Try with a straight table instead of pivot.

Then choose Sum of rows as Total Mode.

Bonne année

Mon, 03 Jan 2011 08:59:01 GMT

thx Mister

but i have another problem i have in my file a periode and i would like to build a table where there are some account compt group by period

exple

compte Period 1 Period 2

100011 100 000 200 000

in the table Period 0 1 2 3 4 5 6 7 8 9 10 11 12

Period1 = Period<=1

the expression that i writre

Sum({$<PERCP={"<=1"}>}((SoDebit+MvtDebit)-(SoCredit+MvtCredit)))

and this expression returns 0