Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentages of total subdimension

Hello

I have the following Table:

Instead of the number of the dimensión GRUPO_SERVICIO I want to have the porcentages that this number represents according to the sum.

Example for the TIENDA COPYFACTORY Instead of have GDF=4,845 METROBUS=85 etc. I want to have the porcentage that these numbers represent according to the total 5,997

Please Help

Thanks in advance

1 Solution

Accepted Solutions
ramoncova06
Partner - Specialist III
Partner - Specialist III

sorry forgot that the grouping is done by store, so switch it to store instead of servicios


Count(TOT_TRAN)/Count(Total <Tienda> TOT_TRAN)

View solution in original post

22 Replies
ramoncova06
Partner - Specialist III
Partner - Specialist III

Leonardo,

que es lo que esperas ver como total el 100% o 5,997?

Not applicable
Author

Me encantaría ver el 5,997 como total

sunny_talwar

What is your current expression?

This is what you need to do:

=Num(Sum(YourMeasurement)/Sum(Total <GRUPO_SERVICIO> YourMeasurement), '#,##0.0%')

HTH

Best,

Sunny

Not applicable
Author

This is my Expression

Count(TOT_TRAN)

When I use the expression that you give to me, all the values go to "0"

Num(Sum(TOT_TRAN)/Sum(Total <GRUPO_SERVICIO> TOT_TRAN), '#,##0.0%')

sunny_talwar

I don't think its going to make any difference, but please try this:

Num(Count(TOT_TRAN)/Count(Total <GRUPO_SERVICIO> TOT_TRAN), '#,##0.0%')

sunny_talwar

Would you be able to share a sample to trouble shoot it a little more

Not applicable
Author

It's the same

sunny_talwar

What is the result when you add another expression :Count(Total <GRUPO_SERVICIO> TOT_TRAN) what value does it give you?

Not applicable
Author

Example:

Now I have:

TIENDA                          GDF             METROBUS            SERVICIOS     TELEFONIA    TELEPEAJE      TOTAL

COPY FACTORY           4,845                  85                            8                     1,059                 -                   5,997

What I want is this:

TIENDA                          GDF             METROBUS            SERVICIOS     TELEFONIA    TELEPEAJE      TOTAL

COPY FACTORY           81%                   1%                         0%                      18%                0%                  5,997