How to associate date field

[GOKULAKANNAN]

Hi Team,

I need to generate a report using a datemonth field (ex: decemeber,2021), and in datemonth field it should show only based on below condition

condition 1: if currentmonth <= 6 then the datemonth drop down should show, 

1) June,current year(Ex: June,2022)

2) Decemeber , Pre-Year (Ex: December,2021)

3) June , Pre-Year (Ex: June,2021)

Condition 2: if currentmonth >= 6 then the datemonth drop down should show, 

1) Decemeber , Pre-Year (Ex: December,2021)

2) June, Pre-Year  (Ex: June,2021)

3) December , Previous year of Pre-Year  (Ex: December,2020)

If you select any one option from the drop down (For Ex: December,2021) and table should show all the data from starting until december 2021.

Table should be shown as below,

Id	Name	Date	Mark
1	kUMAR	12/10/2010	100
2	nARESH	31/10/2011	90
3	RAHUL	07/07/2021	67
4	dEEPAK	08/09/2021	85

How can I link this table with the datemonth field, and this datemonth field should be fixed and it should have only 3 rows always as mentioned above.

[chris_djih]

See this: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130