Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Aggrupate Sum for multiple Rows

Hello,

I have the following table:

DateTypeFormatExpression
28/5/2018Type 1North0,02%
28/5/2018Type 1South0,88%
28/5/2018Type 2West0,12%
28/5/2018Type 2East3,45%
28/5/2018Type 3East1,89%
28/5/2018Type 4West0,02%
28/5/2018Type 4Noth1,36%
28/5/2018Type 5South0,25%
28/5/2018Type 6East1,06%

What I need is to show the sum for each Type like this as a expression:

DateTypeFormatExpression
28/5/2018Type 1North0,90%
28/5/2018Type 1South0,90%
28/5/2018Type 2West3,57%
28/5/2018Type 2East3,57%
28/5/2018Type 3East1,89%
28/5/2018Type 4West1,38%
28/5/2018Type 4Noth1,38%
28/5/2018Type 5South0,25%
28/5/2018Type 6East1,06%

Is there any way to do that?

Thank you!!!

1 Solution

Accepted Solutions
sunny_talwar

It would use TOTAL <Date, Type> in the expression to get this to work

View solution in original post

2 Replies
sunny_talwar

What is the expression you are using?

sunny_talwar

It would use TOTAL <Date, Type> in the expression to get this to work