Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
msantarone
Contributor
Contributor

Participation by column.

Hello, I need to obtain the % participation of the Premio measure in each of the columns per month (not the Total Premio but the Premio of the month).

In the measure "% Dv Premio/ Premio" I use the following formula: Sum (Premio) / Aggr (Sum (Premio), PeriodId) - but it only works well for Mendoza province. Why not go for all?

See attached.

3 Replies
Kushal_Chawda

@msantarone  try below

Sum (Premio) / Sum (total <PeriodId>Premio)

msantarone
Contributor
Contributor
Author

Thanks, but it works the same as column "% Dv Premio / Total Premio"

Kushal_Chawda

@msantarone  try to add first dimension as well

Sum (Premio) / Sum (total <Dim1,PeriodId>Premio)