Discussion Board for collaboration on QlikView Scripting.
=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..
Please see this posts:
YTQ, QTD, MTD and WTD
Previous YTQ, QTD, MTD and WTD
Hope it helps