How to calculate YTD with common Sites - Qlik Community

Report Inappropriate Content · ‎2013-10-01

How to Calculate the YTD WIth common sites..Pls find attached sample file.

tresesco · ‎2013-10-01

Can you please explain a bit more about your required output?

Report Inappropriate Content · ‎2013-10-01

have to calculate YTD of those sites which are common in 2012 and 2013 .In the attached file we have different sites but 101,102,103 are common in 2012 n 2013.

Anonymous · ‎2013-10-01

Hi Saurabh Wadhwa

Create a variable vstartdate,venddate,vpstartdate,vpenddate and go to settings document properties and select trigger, choose variable event trigger and select venddate and add actions

VSTARTDATE=YearStart(VENDDATE)

VPSTARTDATE==AddYears(VSTARTDATE,-1)

VPENDDATE==AddYears(VENDDATE,-1) and final select in field

date= ='>=' & VSTARTDATE & '<=' & VENDDATE

tresesco · ‎2013-10-01

May be like attached sample ? PFA