Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
maxicarena
Creator
Creator

¡ Formula Percent !

Dear, I want to calculate the share of sales (Ventas) by cards (Tarjeta) percentage (% Particip.) but for every month (Mes) in the pivot table when I have opened every month (Mes) I calculated the percentage (% Particip.) of the sale but not closed for each month (Mes) (see image 1), but the divide each sale of card (Tarjeta) but by the total universe of months (Mes). However when I see only an achievement month what I want (see picture 2) in the total of the month I see the participation of 100%.

The formula used in the measure of participation % (% Perticip.) is Sum (Sales) / Sum (Total Sales)

Who can advise me? It is possible in the complete pivot table?

Qlik im 1.jpg

Qlik im 2.JPG

1 Solution

Accepted Solutions
mgranillo
Specialist
Specialist

Try Sum (Sales) / Sum (Total <Mes> Sales)

View solution in original post

4 Replies
mgranillo
Specialist
Specialist

Try Sum (Sales) / Sum (Total <Mes> Sales)

brunobertels
Specialist III
Specialist III

Hi

May be you should use aggr function

somthink like this like this

Sum (Sales) / sum(aggr(sum(Total Sales),Mes))

maxicarena
Creator
Creator
Author

Excellent Michael, works. Thank you so much

maxicarena
Creator
Creator
Author

Thank you very much Bruno for your answer!, already solved