Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
h2k18
Contributor II
Contributor II

Create - Month/Quarter From filter & Month/Quarter To filter

Hi,

I have attached a sample app.

Use case: Need to create two filter objects for users to define the reporting range for the Table. It should be Month/Quarter From and the other one should be Month/Quarter To.
The app has PERIOD field with both Quarter and YearMonth dataset. It also has PERIOD_TYPE to toggle between Month and Quarter. Only one PERIOD_TYPE can be active at any given time.

Output required: By using the two filters the table should populate the Period. For example if the USER selects Month From = 201801 and Month To = 201806 the underlying table should show PERIOD = 201801, 201802, 201803, 201804, 201805 and 201806.

Thanks.

Labels (3)
1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

I'm not sure, but probably you could do something like this (file attached)