topic Re: Show current year data in filter pane qliksense in App Development

Show current year data in filter pane qliksense

Aspiring_Developer — Tue, 21 Sep 2021 13:32:46 GMT

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

Re: Show current year data in filter pane qliksense

RsQK — Tue, 21 Sep 2021 09:43:43 GMT

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.

Re: Show current year data in filter pane qliksense

abhijitnalekar — Tue, 21 Sep 2021 09:46:09 GMT

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')

Re: Show current year data in filter pane qliksense

Aspiring_Developer — Tue, 21 Sep 2021 11:32:24 GMT

@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

Re: Show current year data in filter pane qliksense

Aspiring_Developer — Tue, 21 Sep 2021 11:33:48 GMT

@RsQK

I tried , however, didn't worked.

Re: Show current year data in filter pane qliksense

RsQK — Wed, 22 Sep 2021 05:40:46 GMT

My script (before this just generated some dates):

Front-end: