topic Limit Value on list Box in QlikView

Limit Value on list Box

ivandrago — Thu, 25 Nov 2010 22:53:45 GMT

Hi,

I have a List box based on the field "Year" at the moment it is going back to 2000, I only want it to show the Years that fall with in the last 13 months so I only want it to show 2009, 2010. It is currently showing 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010 which I do not want.

Thanks

Limit Value on list Box

Fri, 26 Nov 2010 08:00:39 GMT

Hi IvanDrago,

I think you can try make the expression listbox for this case.

Limit Value on list Box

Fri, 26 Nov 2010 09:18:40 GMT

Hi Ivan,

From which field you are picking your date. Does this contains years. If yes, you can split the year from you date and define separately in your script. Then create a listbox from the same. I think it would resolve your issue.

Limit Value on list Box

Fri, 26 Nov 2010 09:51:02 GMT

You can use the below expression in the list box

if(Year>=year(addmonths(today(),-13)),Year)

Limit Value on list Box

ivandrago — Fri, 26 Nov 2010 10:25:51 GMT

Where can you put this expression?

Limit Value on list Box

Fri, 26 Nov 2010 10:43:32 GMT

Go to list box properties.

You can see the <Expression> In the field drop down.

Limit Value on list Box

ivandrago — Fri, 26 Nov 2010 11:44:46 GMT

Have you a screen dump of this ? Because I cannot see anywhere where I can put this expression

Limit Value on list Box

Fri, 26 Nov 2010 11:49:28 GMT

Then a window will pop up where u can copy and paste this:

if(Year>=year(addmonths(today(),-13)),Year)