Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (1)
1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

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