SET Help

[QlikAngel]

Hi,

=SUM(AGGR(if(VYEAR = $(PreviousYear),(BEGIN_BALANCE_DR - BEGIN_BALANCE_CR) - (-(PERIOD_NET_DR - PERIOD_NET_CR))),CODE_COMBINATION))

i want to write above expression in set.. as i am coding this for YTD.. is that correct..

What will be for MTD, QTD & Half Yearly.. i need for Previous Month & Previous Year MTD also..

[miguelbraga]

Please see this posts:

YTQ, QTD, MTD and WTD

Previous YTQ, QTD, MTD and WTD

Hope it helps