topic List Box for Year in QlikView

List Box for Year

Phunshey — Thu, 01 Apr 2021 09:09:30 GMT

Hello,

I am new to Qlikview. Apology for asking this question if it is foolish one. I am trying to create a list box for Year. For some reason I get year from 1899 till 2021 even though I have data for 2019 and 2020 only. How do I show only 2019 and 2020 in my list box? I tried looking around in internet but no joy.

Kind regards,

Phunshey

Re: List Box for Year

eddie_wagt — Thu, 01 Apr 2021 09:15:37 GMT

Hello @Phunshey

It probably had something to do with your calendar table. If you click the year 1899 and nothing is being associated, then you have too many years in your calender. I suggest that you restrict the years in the calendar in loadscript by adding a where clause.

Examples where you want to see Year greater of equal to 2010

Calender_example: LOAD Year , Datefield , blabla From table Where Year>=2010 ;

Otherwise you can have a workaround in frontend.

Select 'Calculated dimension' from the properties as Field. Put the following expression in:

aggr(only({$<Year={'>=2010'}>}Year),Year)

Regards Eddie

Re: List Box for Year

Phunshey — Mon, 05 Apr 2021 10:05:22 GMT

Thank you @eddie_wagt . The first solution worked.

Re: List Box for Year

eddie_wagt — Tue, 06 Apr 2021 07:08:40 GMT

@Phunshey great to hear. Happy qliking! 😊