Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
SvanKooten
Contributor
Contributor

Column with grouped sum

Hello, 

In Qlik Sense i need to make a column with the total sum of (sum of hours) per group to make a calculation with this sum. I find it hard to figure out how to get it. 

Can you please help me? i need the last column. Example qvf is attached

Product group Zaaktype Telling van Product Som van Uren needed colum (total (som van uren) per product group)
T.1.01 Behandelen beroep 2 113,5 640,45
T.1.01 Behandelen bezwaar 2 92,25 640,45
T.1.01 Klacht/melding 32 209,45 640,45
T.1.01 Ongewoon voorval 2 16,5 640,45
T.1.01 Verzoek om handhaving 11 208,75 640,45
T.2.01 Behandelen beroep 1 42 845,3
T.2.01 Behandelen bezwaar 1 11,5 845,3
T.2.01 Overige controle bouw 1 1,25 845,3
T.2.01 Toezicht Bestaande bouw 95 779,8 845,3
T.2.01 Toezicht Brandveilig gebruik 1 10,75 845,3
T.2.02 Bouwtoezicht oplevering 171 1035,25 1044
T.2.02 Toezicht Brandveilig gebruik 1 8,75 1044
2 Replies
rubenmarin

Hi, you an use TOTAL to ignore dimensions, and between '<' and '>' the name of the fields you want to group.

So at the end it could be something like: Sum(TOTAL <Product> Uren)

SvanKooten
Contributor
Contributor
Author

Thanks for your answer.