topic Re: Not all the years in QlikView

Not all the years

Tue, 21 Apr 2015 14:56:00 GMT

You see the years 2002 - 2015, but I only want to see the years 2012 - 2015 how can I fix that?

rubenmarin — Tue, 21 Apr 2015 15:00:18 GMT

Hi, you can use an expression in multi-select box, ie:

=If(Year>2012, Year)

=If(Year>=Year(Today())-3, Year)

marcus_malinow — Tue, 21 Apr 2015 15:01:45 GMT

You'll have to limit the data you're loading.

In your load script you can use criteria such as 'where year(YourDateField) >= 2012'

buzzy996 — Tue, 21 Apr 2015 15:01:49 GMT

try this on ur year field on multi box properties

=If(ur year field>='2012',ur year field,null())

prieper — Tue, 21 Apr 2015 15:02:16 GMT

Why? When there are data behind, it might be shown. If no data behind, might be limited in the script.

Anyhow: you may use an expression in the listbox:

IF(YearField >= 2012, YearField)

HTH Peter

marcus_malinow — Tue, 21 Apr 2015 15:03:04 GMT

Correction - as per Ruben's suggestion you can use a calculated dimension, so you don't have to limit the data you're loading.

However, if you're not going to allow it to be selected, why bother loading it?

Tue, 21 Apr 2015 15:04:39 GMT

Here you go