Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

put many dimensions as pivot

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!

1 Reply
pgalvezt
Specialist
Specialist
Author

Hello!

Any Help?

Thanks!