Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
hurricanemoe201
New Contributor III

How to group choices in the filter pane?

Hello,

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

12_12.png

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
YoussefBelloum
Esteemed Contributor

Re: How to group choices in the filter pane?

Hi,

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..