# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

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

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

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

2 Replies
Not applicable

## Re: Calculating Total of YTD Calculation Based

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

Not applicable

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

Community Browser