Skip to main content

New to Qlik Sense

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fernandoflogtz
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?

fernandoflogtz
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