Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Creator II
Creator II

hi ,

          Try using above() function

Highlighted
Partner
Partner

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