Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tas
Contributor
Contributor
‎2021-11-22 10:05 AM

Sales %

Need help to create an expression on sales %. The formula for sales is sum(sales) but I'm not  sure how to do sales %

701 Views
0 Likes
1 Solution

Accepted Solutions
6 Replies
Or
MVP
MVP
‎2021-11-22 10:09 AM

What is "Sales %"? What is this a percentage of?

682 Views
tas
Contributor
Contributor
‎2021-11-22 10:46 AM
Author

In response to Or

This is the relative percentage of Sales for a single value in a dimension field compared to the total of all other possible values in that field

648 Views
0 Likes
Or
MVP
MVP
‎2021-11-22 10:51 AM

Generally, sum(Sales) / Sum(Total Sales) or Sum(Sales) / Sum(Total <Dimension> Sales).

634 Views
0 Likes
tas
Contributor
Contributor
‎2021-11-22 11:05 AM
Author

In response to Or

The issue is I don't have total sales as the data didn't provide that. I am creating all the expressions after I uploaded and associated my data

623 Views
0 Likes
tas
Contributor
Contributor
‎2021-11-22 11:41 AM
Author

In response to Or

Thank you, I got my answer

587 Views
0 Likes