Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

make a sum of table columns

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

3 Replies
spividori
Specialist
Specialist

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.

Not applicable
Author

Hi

Try with a straight table instead of pivot.

Then choose Sum of rows as Total Mode.

Bonne année

JJ

Not applicable
Author

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