Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
julianortiz
Contributor
Contributor

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