Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendragaur
Creator
Creator

Sum of Total Value

Hello All,

I have below Data (Department, Name and Value). 

Expected Output -there should be another column which shows "Total Value" based on each department and when I collapse the group based on Department then it should show same value for column "Value" and "Total Value"

Department Name Value Total Value
a a1 1 6
a a2 2 6
a a3 3 6
b b1 4 15
b b2 5 15
b b3 6 15
c c1 7 24
c c2 8 24
c c3 9 24

 

After Collapsing table based on Department-

 

Department Value Total Value
a 6 6
b 15 15
c 24 24
1 Solution

Accepted Solutions
amrinder
Creator
Creator

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder

View solution in original post

1 Reply
amrinder
Creator
Creator

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder