Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
julianortiz
Contributor II
Contributor II

Set Analysis between Date question

Hi

I have this data

julianortiz_1-1626866565696.png

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

If the user selects Jun-2021, I should see records match with selection (dates between Start and End date)

julianortiz_3-1626866996969.png

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

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.

 

0 Replies