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: 
Not applicable

how to perform above in pivot table

Hi  all

swuehl‌ 

how to we get above functionality in pivot table

for eg:my sample data

 

datechipab
1c1100700
2c1200800
3c1300900
4c14001000
5c15001100
6c16001200

I want column d such that d1=a+b=800 for date 1

for date2=date1 bal+b(of date2) -a(date1)

output

chip123
c1a100200300
c1b700800900
c1bal800800+800-200=14001400+900-300=2000
1 Solution

Accepted Solutions
sunny_talwar

This?

Capture.PNG

Dimensions:

chip

date

Expressions:

=Sum(a)

=Sum(b)

=If(ColumnNo(TOTAL) = 1, Sum(a) + Sum(b), RangeSum(Before(bal), Sum(b), -Sum(a)))

Here bal is the label for the third column (so self referencing label)

View solution in original post

1 Reply
sunny_talwar

This?

Capture.PNG

Dimensions:

chip

date

Expressions:

=Sum(a)

=Sum(b)

=If(ColumnNo(TOTAL) = 1, Sum(a) + Sum(b), RangeSum(Before(bal), Sum(b), -Sum(a)))

Here bal is the label for the third column (so self referencing label)