Re: How to use aggr function - Qlik Community

Report Inappropriate Content · ‎2017-03-10

In the table below, from every row I would like to have ND as MINUTI dived to the sum of all PRG row( i.e. 1440). How to do? Thank you

vinieme12 · ‎2017-03-10

please post sample data in excel with expected output

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2017-03-10

USe TOTAL Keyword

sum(MINUTI) / SUM(TOTAL PRG)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

karthiksrqv · ‎2017-03-10

Hi,

Please try this:

sum(Minuti)/sum(TOTAL PRG)

sunny_talwar · ‎2017-03-10

How is sum of PRG = 1440? Can you share more details as to what kind of object are you using? How many dimensions do you have? What is your expression?