Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Calculated dimension expression. Need help.

=num(Aggr(Sum(Product='A'), Operator_Name, Year, Branch),'#.##0')

Hello, I need to have the Sales Share in % of Product A among all the products, for a given Operator, Year and Branch.
The above expression calculates me the number of records that contain product A for a given Operator, Year and Branch.

Now I need not the number of records for that, but the Sales for that Product. The sales should be in %, which means I need to divide it by 'Sales'. Please come up with a complete formula for sales in % for a product A among all the products with the given dimensions(Operator, Year and Branch). Thanks in advance.

Community Browser