Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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"

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
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