Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Highlighted
mahendragaur
Contributor

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"

DepartmentNameValueTotal Value
aa116
aa226
aa336
bb1415
bb2515
bb3615
cc1724
cc2824
cc3924

 

After Collapsing table based on Department-

 

DepartmentValueTotal Value
a66
b1515
c2424
Labels (1)
1 Solution

Accepted Solutions
amrinder
Contributor

Re: Sum of Total Value

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder

1 Reply
amrinder
Contributor

Re: Sum of Total Value

Hi Mahendraguru,

For Total Value try below expression:

Sum(TOTAL<Department> Value)

-Amrinder