Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

How to get previous month balance

Hi All

I have Pivot table as below

   Qtr ->                 Q4 2012         Q1 2013      Q2 2013       Q3 2013

Begin Period               ???                 105             400              224

End Period                   105                 400             224              156

Previous Month    9/30/2012      12/31/2012    3/31/2013     6/30/2013

The "End Period" is Begin period of next quarter, How do I get these "Begin Period"?
For Q4 2012 Begin Period is Balance from 9/30/2012 (GL_Date)

Your helps are appreciated, Thanking you lot

5 Replies
Highlighted
Specialist
Specialist

Highlighted
Not applicable

you can use PEEK in script to obtain a new field with the previous amount.

Highlighted
Not applicable

I have been using formula

sum({<GL_Date = {'=QuarterEnd(AddMonths(Max(GL_Date), -3))'}, Balance)

Where Dimension is based on GL_Date

Highlighted
Not applicable

Hey Rajendra,

Is it possible to attach a sample source file(may be like in excel)

Thanks

AJ

Highlighted
Not applicable

You can use Above function to get the previous values in the UI level.

=Above([Begin Period]) may work...be sure you order by Quarter field.