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: 
Anonymous
Not applicable

Share from Total Product's Category Sales

Hello everyone,

I am trying to resolve this task: "Add an expression to the chart which will calculate the share of the Sales per Year, Month and Product of the total sales of the product’s ProductCategory. Format the result in %."

I have tried anything but I can't resolve it. Please help!

P.S The dimensions in my report are Year,Month,Product_Category_Name,Product_Name

2 Replies
petter
Partner - Champion III
Partner - Champion III

I think this expression should work for you:

Num( Sum(Sales) / Sum(TOTAL <Year,Month,Product_Category> Sales) , '0.0%')

poojashribanger
Creator II
Creator II

you can use num(expn,'##.00')&'%'