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
Tell us which business and trade publications you read most regularly: RESPOND 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