topic Limiting Data in a List Box in QlikView

Limiting Data in a List Box

Mon, 23 May 2011 11:53:53 GMT

Is there a way to limit the data in a list box. The table my list box pulls data from goes back to 2009. I would like to hahve the list box only pull data from 2011.

Thanx

Limiting Data in a List Box

Mon, 23 May 2011 11:58:38 GMT

Hi,

Use a calculated expression instead of the field itself. For example, if the field in the list box is called "A", create an expression like:

({$<[Year]={2011}>} A)

Limiting Data in a List Box

pat_agen — Mon, 23 May 2011 12:05:43 GMT

hi,

you can enter an expression in your list box. On the general tab of the properties dialogue open the drop down list of fields. Scroll to the top and select <Expression>. the expression dialogue will open. Enter something like this:

=if(Year=2011,fieldToBeDisplayedHere)

hope this helps

Limiting Data in a List Box

Mon, 23 May 2011 12:44:04 GMT

Following your lead, this is the formula I used.

=if(CloseDate_MY >='01-2011',CloseDate_MY)

Unfortunately it's doing noting...as if I didnt type any thing in. Do you see an issue with the syntax?

Limiting Data in a List Box

Mon, 23 May 2011 12:50:30 GMT

I tried the syntax as such:

=({$<{CloseDate_MY} >={01-2011}>} CloseDate_MY)

Unfortunately Im getting error in expression. Any idea?

Limiting Data in a List Box

pat_agen — Mon, 23 May 2011 12:55:11 GMT

hi,

how is the field ClosedDat-MY defined? Is this a date field?

You probably need to do some processing on this field to have it comparable to a string such as '01-2011'. perhaps something like:

if(Date(ClosedDat_MY,'MM-YYYY')>='01-2011',CloseDate_MY)

Limiting Data in a List Box

Mon, 23 May 2011 13:13:05 GMT

Yes, the CloseDate_MY is a date field formatted for MM-YYYY

Limiting Data in a List Box

pat_agen — Mon, 23 May 2011 13:16:56 GMT

did you try the code as posted?

if(Date(ClosedDat_MY,'MM-YYYY')>='01-2011',CloseDate_MY)

Limiting Data in a List Box

Mon, 23 May 2011 13:19:33 GMT

Yes, but unfortunately, there seems to be no effect on the list box...all of the month year data shows back to 2009

Thanx

Re: Limiting Data in a List Box

yasus — Mon, 23 May 2011 13:31:04 GMT

Hi fuji,

I would just add a dedicated field for your listbox within the load script.

Example:

LOAD *,
if(Yearmonth<201102,Yearmonth) as ModListBox
From //