put many dimensions as pivot

pgalvezt — Tue, 20 Jan 2015 20:02:11 GMT

Hi,

I am going to try to explain this problem.

I have a dimension (Departamento). This Dimension brings many items:

-Ingresos de la explotacion

-Costo de ventas

-Otros ingresos de la explotacion

etc

I would like to do many calculations with this items and try to clone an excel file: as a QlikView Pivot.

For Example:

Excel File:

Ventas: 6347

Costo de Ventas: -4331

Margen de Explotacion: 2027

I would like to create the same excel file in QlikView.

I don´t want to see "otros ingresos de la explotacion" Just Ventas, Costo de Ventas, and Margen.

Besides I want to add another row with % (Margen de Contribucion/Ventas)

and another row add the GAV.

Thanks!

Re: put many dimensions as pivot

pgalvezt — Wed, 21 Jan 2015 12:18:51 GMT

Hello!

Any Help?

Thanks!