Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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