Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mayuridg
Contributor

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
Valued Contributor III

Re: SET Help

Please see this posts:

YTQ, QTD, MTD and WTD

Previous YTQ, QTD, MTD and WTD

Hope it helps

Community Browser