How to associate date field

GOKULAKANNAN — Thu, 10 Feb 2022 08:32:12 GMT

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.

Re: How to associate date field

chris_djih — Mon, 14 Feb 2022 14:50:43 GMT

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

topic How to associate date field in App Development

How to associate date field

Re: How to associate date field