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: 
Not applicable

Calculating Total of YTD Calculation Based

Hi There,

             I am quite new to  both Qlikview as well as the discussion Forum. I have a problem with Calculating Total for a Calculated field which is YTD Calculation

The Formula of YTD Calculation, which works on single selection , is attached below.It Works when I select only one OrgUnitName but When I choose Multiple orginsational Unit it Shows 0.

What I am trying to achive is Total of YTD at theTotal Level. Pictures Attached for Examples

********************************************

sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"},OrgUnitName={"$(=(OrgUnitName))"}>} (GLTotalAccountCredits+GLTotalAccountDebits))

*************************************

Please help.

1 Solution

Accepted Solutions
Not applicable
Author

Yahoo I have Figured Out the Calculation, Very Happy ....Yahoooooo!!!!!!!!!!!!!!

Here is it.

IF(ParaquadTotalName='Total',(SUM({<ParaquadTotalName ={'Total'} >} (Aggr(sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"}>} (GLTotalAccountCredits+GLTotalAccountDebits)),OrgUnitName,TreeName)))),(SUM({<ParaquadTotalName = >} (Aggr(sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"}>} (GLTotalAccountCredits+GLTotalAccountDebits)),OrgUnitName,TreeName)))))

View solution in original post

2 Replies
Not applicable
Author

Can you upload your sample application. will do the needful for you.

Not applicable
Author

Yahoo I have Figured Out the Calculation, Very Happy ....Yahoooooo!!!!!!!!!!!!!!

Here is it.

IF(ParaquadTotalName='Total',(SUM({<ParaquadTotalName ={'Total'} >} (Aggr(sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"}>} (GLTotalAccountCredits+GLTotalAccountDebits)),OrgUnitName,TreeName)))),(SUM({<ParaquadTotalName = >} (Aggr(sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"}>} (GLTotalAccountCredits+GLTotalAccountDebits)),OrgUnitName,TreeName)))))