Add Rows on Pivot Tables

Mon, 09 Mar 2015 20:37:12 GMT

I need this format on my pivot table.

I have a relation of Division-->Group-->Company

I have values of company, group totals, division totals and percentage already loaded as results but they are on columns and I want the pivot table to stay in those 3 columns size but scrolling down, showing result of group totals, division totals and percentage under the last column. (Column 3)

How can I get to move those 3 rows (group totals, division totals and percentage) under the company totals??

It looks like qlikview does not allow to add rows so what can I do?

Re: Add Rows on Pivot Tables

Mon, 09 Mar 2015 20:47:17 GMT

You will need another table with this 3 rows. The dimension of this table you can create with a Valuelist.

In the attachment you will find a sample of using a Valuelist.

Re: Add Rows on Pivot Tables

Wed, 11 Mar 2015 21:07:54 GMT

I tried using Valuelist but I can't show that table format that I want. Maybe there's something missing that I'm not doing well. I can create the table with valuelist but what do I do next??
I tried on the script editor:

AddRowTable:
LOAD * Inline [Company Totals,Group Totals, Division Totals, Percentage (blank row for the percentage)];

How do I combine it into the pivot table? with a Join?

Re: Add Rows on Pivot Tables

Fri, 13 Mar 2015 22:30:40 GMT

Sorry but I can't figure out how to do this!!! Please I need help!

I have the following script:

Division:

LOAD IDDivision, NombreDivision as División;

SQL SELECT *

FROM "Divisiones";

Companias:

LOAD IDCompania, IDDivision, NombreCompania AS Compañía, IDGrupo, SecuenciaListado, Desactivada;

SQL SELECT *

FROM "Companias"

WHERE Desactivada = 0

ORDER BY SecuenciaListado, IDCompania;

Grupo:

LOAD IDGrupo, NombreGrupo as Grupo;

SQL SELECT *

FROM "Grupos";

Calendario:

LOAD date(FechaAListar,'DD/MM/YYYY') as [Fecha de Venta],

date(FechaMisma,'DD/MM/YYYY') as [Fecha Anterior Actual],

date(FechaAComparar,'DD/MM/YYYY') as [Fecha Anterior Siguiente];

SQL SELECT FechaAListar, FechaMisma, FechaAComparar

FROM "CalendariodeFechas"

WHERE YEAR(FechaAListar) >= 2010

ORDER BY FechaAListar DESC;

DetalleVentas:

LOAD IDCompania,

date(FechaVenta,'DD/MM/YYYY') as [Fecha de Venta],

VentaDelDia as [Ventas del Dia],

PromedioDelDia as [Promedio Anual del Dia];

SQL SELECT IDCompania, FechaVenta, VentaDelDia, PromedioDelDia

FROM "Detalle Ventas del Dia"

WHERE YEAR(FechaVenta) >= 2010

ORDER BY FechaVenta DESC;

I only have one calender object for selecting date of sale (Fecha de Venta).

I need the exact following format:

%percentage3 %percentage6

%percentage3 %percentage6%

%percentage3 %percentage6%

%percentage3 %percentage6%

%percentage3 %percentage6%

I hope I make it clear enough.

I thought creating a straight table from scratch using script editor. Maybe I'm getting close...

Somebody help! It will help me and other QV developers Gratitud.

topic Re: Add Rows on Pivot Tables in QlikView

Add Rows on Pivot Tables

Re: Add Rows on Pivot Tables

Re: Add Rows on Pivot Tables

Re: Add Rows on Pivot Tables