Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikAngel
Partner - Creator
Partner - Creator

SET Help

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

1 Reply
miguelbraga
Partner - Specialist III
Partner - Specialist III

Please see this posts:

YTQ, QTD, MTD and WTD

Previous YTQ, QTD, MTD and WTD

Hope it helps