topic Show date for current year in filter pane qliksense in App Development

Show date for current year in filter pane qliksense

Aspiring_Developer — Tue, 21 Sep 2021 14:13:37 GMT

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 — Tue, 21 Sep 2021 14:20:56 GMT

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

Aspiring_Developer — Tue, 21 Sep 2021 16:12:26 GMT

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