topic Calculating Total of YTD Calculation Based in QlikView

Calculating Total of YTD Calculation Based

Tue, 19 Mar 2013 05:05:33 GMT

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.

Re: Calculating Total of YTD Calculation Based

Tue, 19 Mar 2013 05:22:10 GMT

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

Re: Calculating Total of YTD Calculation Based

Tue, 19 Mar 2013 05:34:04 GMT

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