Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: how to perform above in pivot table

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)

1 Reply

Re: how to perform above in pivot table

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)

Community Browser