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: 
nirav_bhimani
Partner - Specialist
Partner - Specialist

How to add last row particular column data value to next row in the pivot table?

Hi Everyone,

I want Pivot Table as following:

TrasactionNo         Date             MainBalance      Dr      Cr      CurrentBalance

1                          15-1-11             1000             100     -          900

2                          16-1-11            900               100     -          800

3                          16-1-11            800                -       500     1300

In the above case my each CurrentBalance become the MainBalance for next column. 

So please proivde me any solution for that.

Thanks & Regads,

Nirav Bhimani

2 Replies
Anonymous
Not applicable

hi ,

          Try using above() function

nirav_bhimani
Partner - Specialist
Partner - Specialist
Author

HI,

I want my current balance as a MainBalance in next row.

I have use the following set exp

=if(RowNo(TOTAL)='1'

          ,$(v_OpeningBal)

          ,(Above(Column(4))))

its working only for First four records which having same date, if date changes then its not showing any value.

Regads,

Nirav Bhimani