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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Kate192731
Contributor
Contributor

TOTAL

Hi, All!
Help me, Please!!!!
I need to display the totals for the column 'ДОГОВОР' but QLIK does not output, although

-InUe-nzMlQ.jpg


if you swap the columns, everything happens as it should.

JuGE8RhYP2I.jpg

 

The problem is that I can't swap columns: the 'ДОГОВОР' column should go first

 

please help me. I've tried everything and I don't know what to do



3 Replies
QFabian
MVP
MVP

Hi, check the 'Show Partial Sums' for each dimension Field

QFabian_1-1604592031941.png

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
QFabian
MVP
MVP

And if are a lots of rows, you can show totals on top instead of  at bottom:

QFabian_2-1604592177160.png

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
Kate192731
Contributor
Contributor
Author

Thanks for your reply!!!
But Partial sums I have on the field "ДОГОВОР", I need. But the problem is that I don't understand why in the moment when I change the column order , the results become partial and total
I need the totals for each 'ДОГОВОР', that is, when the 'ДОГОВОР' ID is changing, there is a result, i.e. is present as a aggregation (the totals partition by 'ДОГОВОР'
I need the result that I get in photo number 2 , that is, for each 'ДОГОВОР' ID, I have partial sums (the only problem is that the order of columns has been changed here), but I don't have the right to change
it. And I don't understand why QLIK doesn't like the order of columns. Why does it depend on the order of columns, whether it outputs partial sums (as I need), or outputs total amounts for the entire column "ДОГОВОР'?