Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Luisanabria
Contributor III
Contributor III

get % participation of a measure?

Hi All,

l want to get the % of participation of a measure called Forecast 2022 that is made by

Sum (Sales) + Sum(Forecast) = Forecast 2022

as example, l asked this but for a field of my script, in this case:

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

so l tryed with this but it doesn't work for Forecast, what can l do? or is how can l calculate this?

Thank you

 

 

 

 

Labels (4)
2 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

It is difficult to help without understanding more. The total function gets all data disregarding the dimension values. For example a chart with country as dimension and measure sum(Sales)/sum(total Sales) gives the share of sales for each country. Is that what you are trying to do?

What dimension are you using? What error are you getting?

Luisanabria
Contributor III
Contributor III
Author

Hi Morgan

In this case, l have this table, what l want is the % of Forecast 2022, Forecast 2022 is a measure compound of Sales + Forecast.

So l know is sum(Sales)/sum(total Sales) as you say to get that but with that measure doesnt work good, my question is why? or what lm doing wrong 

fernandoflogtz_1-1664202851207.png

 

this is what lm doing is this:

fernandoflogtz_2-1664203502926.png