Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I'm trying to get the closing YTD balance for last financial year

I'm trying to get the closing YTD balance for last financial year- how do I write the expression using the following 3 seperate dimensions  SUM(GLBal.YTDActual) where the ( year =(X_REPORTING_YEAR)-1) & period = and GLPeriod.PeriodMonth=12

Thanks

2 Replies
nagarjuna_kotha
Partner
Partner

May be like this  ..

Sum({<year ={' $(VmaxYear) '},GLPeriod.PeriodMonth={'12'},period ={'12'}>} GLBal.YTDActual)

Variable:  VmaxYear =    " =Max(X_REPORTING_YEAR)-1"





-Nagarjun

nagarjuna_kotha
Partner
Partner

If its not working,

Try to share sample data accoding ur requirement..

-Nagarjun