2 Replies Latest reply: Mar 19, 2013 1:34 AM by Suman Saha

# 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))

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

• ###### Re: Calculating  Total of YTD Calculation Based

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

• ###### Re: Calculating  Total of YTD Calculation Based

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)))))