Skip to main content

# New to Qlik Sense

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Search instead for
Did you mean:
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
Creator

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder

1 Reply
Creator

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder

Tags
Community Browser