topic Re: Select FIELD - Question! :) in QlikView

Select FIELD - Question! :)

qlikviewaf — Thu, 23 Nov 2017 17:27:35 GMT

Hi,

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

Thanks

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:31:55 GMT

How you want to assign this?

1) OnOpen Document

2) Fuzzy Search

3) after selection one year?

qlikviewaf — Thu, 23 Nov 2017 17:33:30 GMT

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

mdmukramali — Thu, 23 Nov 2017 17:36:56 GMT

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 — Thu, 23 Nov 2017 17:37:09 GMT

if(year>2016,year) on the listbox

Anil_Babu_Samineni — Thu, 23 Nov 2017 17:39:50 GMT

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

You need to use default in listbox?

qlikviewaf — Thu, 23 Nov 2017 17:45:34 GMT

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 — Thu, 23 Nov 2017 17:48:58 GMT

Perhaps this?

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

MarcoWedel — Fri, 24 Nov 2017 00:08:21 GMT

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

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

hope this helps

regards

Marco