Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
muujguu21
New Contributor

How to calculate 'Sales share' expression: Set or Aggr?

Hi Experts - Kindly find attached my qvw file..

I have a simple monthly sales data. So, I need to calculate Manufactures share by month. I have tried with expression like =sum(Sales)/sum(Total Sales)*100, It works fine when i selected all Manufactures or Brands. But if i select 2 or 3 Brands then shares has calculated from those 3 brands.

I am sorry about my poor English. I have prepared a template with my QVW file.

2 Replies

Re: How to calculate 'Sales share' expression: Set or Aggr?

Looks like working. What is the issue?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: How to calculate 'Sales share' expression: Set or Aggr?

May be you need this

Sum([Sales (L)])/Sum(Total {<Manufactures, Brands>} [Sales (L)])*100