Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
spividori
Valued Contributor

Average

Hi.

I need to calculate the percentage in a pivoting table with 2 dimensions, Imputation and Year. I use Sum (Quantity) / Sum (Total Amount) but it does not work. I have tried several without success.

Desired result:Captura.PNG

Captura1.PNG

1 Solution

Accepted Solutions
Highlighted

Re: Average

May be this

Sum(Quantity)/Sum(TOTAL <Ano> Quantity)

View solution in original post

3 Replies
Highlighted

Re: Average

May be this

Sum(Quantity)/Sum(TOTAL <Ano> Quantity)

View solution in original post

Highlighted
mysail25
Contributor

Re: Average

Sum(Quantity)/Sum(TOTAL <Ano> Quantity)

Highlighted
spividori
Valued Contributor

Re: Average

Hi.

Thanks for answering. It works perfect.

Regards.