Subset of field values in filter pane

[morenoju]

Hi guys,

I have a calendar in Qlik Sense with a date field called Date_A. In a filter pane, instead of showing all its values, I'd like to show last month and current month until today:

=if (Date_A<=Today(0),
if (InMonth(Date_A,Today(0),-1),Date_A,
if(InMonth(Date_A,Today(0),0),Date_A)))

The expression works fine, in the filter pane I only see the dates for last month and this month until today.

But when I make a selection, instead of Date_A='1/15/2019' what I get is:

=if (Date_A<=Today(0),
if (InMonth(Date_A,Today(0),-1),Date_A,
if(InMonth(Date_A,Today(0),0),Date_A)))='1/15/2019'

It's not Date_A what it's taking the value, so my charts don't work.

Any idea on what to do to get this to work?

Thanks!

Juan

[Gabriel]

Hi,

Can you upload a sample data with the calendar? This will help with solutions