topic Re: TOTAL in QlikView

TOTAL

Kate192731 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

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

Re: TOTAL

QFabian — Thu, 05 Nov 2020 16:00:45 GMT

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

Re: TOTAL

QFabian — Thu, 05 Nov 2020 16:02:51 GMT

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

Re: TOTAL

Kate192731 — Thu, 05 Nov 2020 18:51:18 GMT

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 "ДОГОВОР'?