Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. | |
Total | 100 | 100% |
Category 1 | 60 | 60% |
Product A | 40 | 67% |
Product B | 20 | 33% |
Category 2 | 40 | 40% |
Product C | 30 | 75% |
Product D | 10 | 25% |
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,
Hi,
I am assuming you are using a pivot table, in which case I think you need to use Dimensionality, similar to below;
Cheers,
Chris.
Hi,
I am assuming you are using a pivot table, in which case I think you need to use Dimensionality, similar to below;
Cheers,
Chris.
Thanks a lot. It's working.
God Blessed you