YTD

[Rcp_17]

May I know how to create YTD for my data set below?

I don't have a date format like, 31/1/2019.

Am new to Qlik, thanks for your help!

	Prior Year
	Act	Act	Act	Act	Act	Act	Act	Act	Act	Act	Act	Act
Account	M01	M02	M03	M04	M05	M06	M07	M08	M09	M10	M11	M12
AAA	27.09	42.00	29.37	25.95	27.25	15.51	31.34	21.16	13.00	29.21	30.72	51.62
BBB	10.68	11.10	12.68	11.00	15.48	9.00	13.58	14.35	13.87	12.74	16.67	12.76
CCC	(0.00)	0.00	(0.00)	0.00	0.00	(0.00)	0.00	(0.00)	(0.00)	(0.00)	0.00	(0.00)
DDD	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
EEE	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
FFF	0.16	0.40	0.21	0.21	0.20	0.19	0.16	0.17	0.15	0.08	0.02	0.21

[Rcp_17]

Actually, the row "Prior Year" covers all from M01 to M12.

[Brett_Bleess]

I believe Set Analysis is likely the best way to go, check the following Design Blog post, hopefully they will help get you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

There is a link to the Primer post on this one, so you can review that one too if need be, hopefully this helps.

Regards,
Brett