Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

How to group choices in the filter pane?


I have a report with a drop-down filter that shows the month-year as the choices. Please see screenshot here:


I was wondering, how can I set the filter up as to show the "Dec-2017" option to show only once, instead of many times as in the screenshot? How can I group this repeating label? Currently, I have this function in the field:

(Date([Opportunity.CreatedDate] - 5/24, 'MMM-YYYY'))

Thank you in advance for your assistance!

Tags (1)
1 Reply
Esteemed Contributor

Re: How to group choices in the filter pane?


I don't think you can do this on the filter of the Table, you can add a "filter line" above the table and add the dimensions with DISTINCT..