Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Set analysis

Hello,

excuse me but I have another problem with set analysis.

I need to calculate in a table an expression to have the percentage of Sales for each item to total.

Please can you help me?

Thnak you very much.

Best regards.

1 Solution

Accepted Solutions
sunny_talwar

This won't require set analysis. Try something like this:

Sum(Sales)/Sum(TOTAL Sales)

View solution in original post

5 Replies
sunny_talwar

This won't require set analysis. Try something like this:

Sum(Sales)/Sum(TOTAL Sales)

Anonymous
Not applicable
Author

Hi,

if I understand right try with this:

sum({1}SalesAmount)/sum({1}Total SalesAmount)

Regards

sorrakis01
Specialist
Specialist

Hi,

Sum(Sales Item)/Sum(TOTAL Sales Item)

Regards

sushil353
Master II
Master II

Hi,

Simply select the option Relative for the particular expression

Not applicable
Author

Yes!

Thank you very much!

Best regards!