Hi
I have this data
![julianortiz_1-1626866565696.png julianortiz_1-1626866565696.png](https://community.qlik.com/t5/image/serverpage/image-id/58930iAB6AAEAC6C288C87/image-size/medium?v=v2&px=400)
I'm building a Straight table to show historical records, depending on a field selection ([Calendar Month Year])
e.g. If the user selects Jul-2021, i should see all records
![julianortiz_2-1626866768672.png julianortiz_2-1626866768672.png](https://community.qlik.com/t5/image/serverpage/image-id/58931iB782508DA5AC6E4F/image-size/medium?v=v2&px=400)
If the user selects Jun-2021, I should see records match with selection (dates between Start and End date)
![julianortiz_3-1626866996969.png julianortiz_3-1626866996969.png](https://community.qlik.com/t5/image/serverpage/image-id/58932iE13FF318DD577BD1/image-size/medium?v=v2&px=400)
I am using this expression with Set Analysis in my Dimension
=Aggr(Only({
<
MonthYear = ,
[Program Name] = {'Prog 1'},
[Enrollment Status End Date]={"<=$(=MonthEnd(Max([Calendar Month Year])))"}
>
+
<
MonthYear=,
[Program Name] = {'Prog 1'},
[EnrollMent Status End Date Status] = {1}
>
}
Customer),
Customer
)
Currently, when i select Jun-2021, only shows
![julianortiz_4-1626867529537.png julianortiz_4-1626867529537.png](https://community.qlik.com/t5/image/serverpage/image-id/58933iDC6D9436CF1B1B94/image-size/medium?v=v2&px=400)
Any suggestions?
Thanks in advance.
Note1: [EnrollMent Status End Date Status] field is for check if the value is null (1: null, 0: not null).
Note2: [Calendar Month Year] field is from an island table.