Show date for current year in filter pane qliksense

[Aspiring_Developer]

Hello All,

I have below data :-

Input Date:-

I want to show the dates only for current year . i tried below :-

=Date(aggr(only({<INPUT_DATE = {">=$(=Date(Yearstart(today()-1)))<=$(=Date(today()))"}>}INPUT_DATE),INPUT_DATE),'MMM-YY')

I am able to get the dates for current year but i am getting repetitive records like below :-

I know it is because in the original date field we have data like this 1/1/2021, 1/2/2021..so on

Is there any way that I can show only record like Jan 2021, Feb 2021 and so on .. in filter pane.

Thanks in advance

@Kushal_Chawda 

[Kushal_Chawda · Accepted solution]

@Aspiring_Developer  try below

=Date(monthstart(aggr(only({<INPUT_DATE = {">=$(=Date(Yearstart(today()-1)))<=$(=Date(today()))"}>}INPUT_DATE),INPUT_DATE)),'MMM-YY')

[Aspiring_Developer]

Hi @Kushal_Chawda 

Thank You for the answer.

If  i have to combine week number in this filter, how can i restrict the same ?

I have week numbers like below :-

How can i combine my week number and input month in one field and show it in filter pane like :-

Sept 2021 & week 36

This will help user to understand what week  number is aligned with each month .

Can you please help me ?

Thanks in advance