topic Re: Total in different place in QlikView

Total in different place

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

Hello,

¿Is is possible to have the pivot table total for example on the middle?

Thank you

Re: Total in different place

niclaz79 — Thu, 22 Jun 2017 12:12:51 GMT

Hi,

Not sure exactly what your use case would be, but total can only be on the top or bottom. However you may have totals on each hierarchy level on the pivot, by clicking in 'Partial Sums' in the 'Presentation' tab.

Re: Total in different place

sunny_talwar — Thu, 22 Jun 2017 12:15:36 GMT

Can be programmed in a different way, can you share a sample?

Re: Total in different place

Peter_Cammaert — Thu, 22 Jun 2017 12:16:07 GMT

Are you trying to create a P&L-like layout in your pivot table?

Re: Total in different place

Anonymous — Thu, 22 Jun 2017 12:23:46 GMT

for example:

segment	value
segment1	2
segment2	4
total	12
segment3	6

Re: Total in different place

Peter_Cammaert — Thu, 22 Jun 2017 12:26:17 GMT

You may put subtotals and aggregations of any kind wherever you like. But it means some additional work is to be performed, as QV isn't capable of doing this on its own.

See here for an example of P&L layouts: How IntervalMatch Solved My Profit and Loss Dilemma

Re: Total in different place

fkeuroglian — Thu, 22 Jun 2017 12:26:43 GMT

Pablo how are you?

Not posible to create this in the same table, could you create in two different tables and using disegn create as like one

Hope help.

Fernando K.