Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
phaelcosta
Contributor
Contributor

Percentage Representativeness

Hi guys,

I am new in Qliksense. Can you help me in this question?

I need to make a percentage representativeness, like a table below:

 Sales% Repres.
Total100100%
Category 16060%
Product A4067%
Product B2033%
Category 24040%
Product C3075%
Product D1025%

 

The % of product is divided by category. In Qliksense I use the expression =SUM(Sales) / SUM(TOTAL(Sales)), but only category is correct, the products not.

What is the correct expression?

Regards,

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

I am assuming you are using a pivot table, in which case I think you need to use Dimensionality, similar to below;

20200729_1.png

Cheers,

Chris.

View solution in original post

2 Replies
chrismarlow
Specialist II
Specialist II

Hi,

I am assuming you are using a pivot table, in which case I think you need to use Dimensionality, similar to below;

20200729_1.png

Cheers,

Chris.

phaelcosta
Contributor
Contributor
Author

Thanks a lot. It's working.

God Blessed you