Show current year data in filter pane qliksense

[Aspiring_Developer]

Hello All,

I have below field where the data is commencing from 2010 till now. 

My requirement is i have to show the data only for current year in this filter pane i.e it should show the dates starting from jan 2021 till the maximum. I don't know how to restrict this in filter pane.

@Kushal_Chawda 

Can anyone please help ?

Thanks in advance

[RsQK]

Hey, could be something like this:

=AGGR({<INPUT_YEAR={"$(=MAX(INPUT_YEAR))"}>}MIN(INPUT_DATE),INPUT_DATE)

You would need to create a year dimension from INPUT_DATE for this.

[abhijitnalekar]

Hi,

You can create a separate Currentyear date filed in the model and use the same field in the filter pane.

like below

'>=' & Date(YearStart(Max(Date)), 'MM/DD/YYYY') & '<=' & Date((Max(Date)), 'MM/DD/YYYY')

[Aspiring_Developer]

@abhijitnalekar 

'>=' & Date(YearStart(Max(Date)), 'MM/DD/YYYY') & '<=' & Date((Max(Date)), 'MM/DD/YYYY')

This didn't worked in backend . Am i doing it correct ?

error - invalid expression

[Aspiring_Developer]

@RsQK 

I tried , however, didn't worked.

[RsQK]

My script (before this just generated some dates):

Front-end: