Trailing Sales for 12 months

[Charu_1628]

Please find the attached data and i have to write a set expression in qliksense for the trailing 12months,

here i don't have date in my data but only the months and year.

kindly provide the solution to the above query urgently

[Charu_1628]

Year	Month	Unit Name	Sales
2021	4	B208+Chetak	1891.18
2021	4	GFPL-Mfg.	499.54
2021	4	GFPL-Trading	180.39
2021	4	FP	1038.98
2021	4	SKG	1003.36
2021	4	Vizag	824.04
2021	5	B208+Chetak	1785.90
2021	5	GFPL-Mfg.	663.84
2021	5	GFPL-Trading	337.13
2021	5	FP	1180.61
2021	5	SKG	1116.52
2021	5	Vizag	773.98
2021	6	B208+Chetak	2183.78
2021	6	GFPL-Mfg.	610.22
2021	6	GFPL-Trading	273.13
2021	6	FP	1158.39
2021	6	SKG	1247.05
2021	6	Vizag	985.59
2021	7	B208+Chetak	1204.50
2021	7	GFPL-Mfg.	569.11
2021	7	GFPL-Trading	215.73
2021	7	FP	767.75
2021	7	SKG	1163.59
2021	7	Vizag	903.51
2021	8	B208+Chetak	2963.05
2021	8	GFPL-Mfg.	653.74
2021	8	GFPL-Trading	341.04
2021	8	FP	1181.80
2021	8	SKG	1388.25
2021	8	Vizag	1018.61
2021	9	B208+Chetak	2962.10
2021	9	GFPL-Mfg.	728.61
2021	9	GFPL-Trading	251.38
2021	9	FP	1312.39
2021	9	SKG	1405.85
2021	9	Vizag	1685.73
2021	10	B208+Chetak	2812.39
2021	10	GFPL-Mfg.	766.98
2021	10	GFPL-Trading	309.14
2021	10	FP	1285.43
2021	10	SKG	1388.37
2021	10	Vizag	1241.34
2021	11	B208+Chetak	2561.90
2021	11	GFPL-Mfg.	489.24
2021	11	GFPL-Trading	179.73
2021	11	FP	1112.71
2021	11	SKG	1228.46
2021	11	Vizag	882.90
2021	12	B208+Chetak	2857.22
2021	12	GFPL-Mfg.	806.84
2021	12	GFPL-Trading	370.59
2021	12	FP	1464.61
2021	12	SKG	1282.06
2021	12	Vizag	1532.19
2022	1	B208+Chetak	2368.48
2022	1	GFPL-Mfg.	676.61
2022	1	GFPL-Trading	335.02
2022	1	FP	1195.51
2022	1	SKG	1069.42
2022	1	Vizag	1187.84
2022	2	B208+Chetak	2588.50
2022	2	GFPL-Mfg.	748.18
2022	2	GFPL-Trading	331.36
2022	2	FP	1216.37
2022	2	SKG	1023.24
2022	2	Vizag	1032.84
2022	3	B208+Chetak	2343.99
2022	3	GFPL-Mfg.	764.08
2022	3	GFPL-Trading	358.39
2022	3	FP	1097.33
2022	3	SKG	1116.14
2022	3	Vizag	1060.37
2022	4	B208+Chetak	1881.43
2022	4	GFPL-Mfg.	590.93
2022	4	GFPL-Trading	250.33
2022	4	FP	1059.26
2022	4	SKG	924.98
2022	4	Vizag	957.04
2022	5	B208+Chetak	2431.42
2022	5	GFPL-Mfg.	656.93
2022	5	GFPL-Trading	213.97
2022	5	FP	1076.88
2022	5	SKG	1232.35
2022	5	Vizag	996.91
2022	6	B208+Chetak	2414.42
2022	6	GFPL-Mfg.	598.39
2022	6	GFPL-Trading	224.88
2022	6	FP	1121.93
2022	6	SKG	1221.98
2022	6	Vizag	1026.44
2022	7	B208+Chetak	1130.16
2022	7	GFPL-Mfg.	429.00
2022	7	GFPL-Trading	161.84
2022	7	FP	832.22
2022	7	SKG	1180.40
2022	7	Vizag	912.60
2022	8	B208+Chetak	1130.16
2022	8	GFPL-Mfg.	429.00
2022	8	GFPL-Trading	161.84
2022	8	FP	832.22
2022	8	SKG	1180.40
2022	8	Vizag	912.60

[BrunPierre]

I'd create a Date in the script

MakeDate(Year,Month,1) as Date

Then use this expression

Sum({<Date={"$(='>=' & Date(MonthStart(Max(Date), -12)) & '<' & Date(MonthStart(Max(Date))))"}>} Sales)

[Charu_1628]

Hey,Thanks .

But it's not working properly.

Actually, Suppose if I'm in September right now  then its should reflect the values from Sep21-Aug22.

this is not happening.

[BrunPierre]

Sum({<Date={"$(='>=' & Date(MonthStart(Max(Date), -11)) & '<' & Date(MonthStart(Max(Date))))"}>} Sales)