Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Percentaje per dimension

Hola, necesito calcular dos porcentajes diferentes en la pivot, que tiene Nombre(dimension1) y Producto(Dimension2)

Para cada nombre debe ser del total 1200 y para cada producto de cada nombre

Percentaje.png

Labels (2)
1 Solution

Accepted Solutions
AngeloBaruffi
Partner
Partner

Hola,

Prueba esta medida:

if(Dimensionality()=1,
     Sum(Valor)/Sum(Total Valor), Sum(Valor)/Sum(Total <Cargo> Valor)
)

View solution in original post

2 Replies
AngeloBaruffi
Partner
Partner

Hola,

Prueba esta medida:

if(Dimensionality()=1,
     Sum(Valor)/Sum(Total Valor), Sum(Valor)/Sum(Total <Cargo> Valor)
)

Channa
Specialist III
Specialist III

if(dimentnality()=1, sum(val)/Sum(total val)

Channa