Select FIELD - Question! :)

[qlikviewaf]

Hi,

there's a way to allow the user to select only YEAR greater than 2015?

Thanks

[Anil_Babu_Samineni]

How you want to assign this?

1) OnOpen Document

2) Fuzzy Search

3) after selection one year?

[qlikviewaf]

i just want that no one should be able to see Year lower than 2016

[mdmukramali]

Hi,

Try This ;

=If(Year>=2016,Year)

if you don't want to show the data itself before 2016 apply the where condition in the script level .

[YoussefBelloum]

if(year>2016,year) on the listbox

[Anil_Babu_Samineni]

What is the logic behind, That means if some one select 2016 you need to display 2016 , 2017 ...

OR

You need to use default in listbox?

[qlikviewaf]

Well, probably the best thing is to change the script and don't load the data before 2016.

The reason is that data coming from year before 2015 are not validated - so i don't want to show nothing.

[Anil_Babu_Samineni]

Perhaps this?

Load Field1, Field2, Year From Table Where Year > 2015;

[MarcoWedel]

another list box expression (on General tab / Field) might be:

Aggr(Only({1<YEAR={">2015"}>} YEAR),YEAR)

hope this helps

regards

Marco