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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 "ДОГОВОР'?