% of Participation

[LuisM]

Hi all,

I have this table:

Im trying to calculate the  % of participation from my TOTAL SALES for every Sales Executive Amount but my result still 0

Any can help me how to solve it? 

l was trying with this: Monto Mn Bruto SKU = TOTAL SALES

 

Thanks 

[vinieme12 · Accepted solution]

Use the total keyword as below for example

Sum(Sales)/Sum(TOTAL Sales)

https://community.qlik.com/t5/QlikView-App-Dev/TOTAL-ALL-DISTINCT-IN-SET-ANALYSIS/td-p/1086575?searc...

[LuisM]

Thank u vinieme12

l was using this  without TOTAL.

max(Aggr(sum([Monto Mn Bruto SKU]),[Ejecutivo Ventas DetFac])) /Sum(([Monto Mn Bruto SKU]))

Now l use

max(Aggr(sum([Monto Mn Bruto SKU]),[Ejecutivo Ventas DetFac])) /Sum(Total([Monto Mn Bruto SKU]))

and It works, thank you

[vinieme12 · Accepted solution]

You don't need Aggr() as all measures aggregate based on the dimensions used in the chart,

unless you are aggregating on a dimension that is not used in the chart or on a different level of granularity 

Try below 

sum([Monto Mn Bruto]) /Sum(Total [Monto Mn Bruto SKU])

[LuisM]

NICE!!

I didnt know that, as was using the fiel "EjecutivoName", l thought AGGR was neccesary but now is more clear. I try without aggr and works same

Thank you very much for always help. 

[vinieme12]

Refer these articles for more

https://community.qlik.com/t5/Qlik-Design-Blog/Use-Aggregation-Functions/ba-p/1475833 

https://community.qlik.com/t5/Qlik-Design-Blog/It-s-all-Aggregations/ba-p/1465669