topic List box value limit. in QlikView

List box value limit.

Thu, 27 Feb 2014 17:40:45 GMT

I have a list box with filed name Year and it has values from 1995 to 2020.(From the master calender)

I only want to display 2014,2103,2012,2011,2010 in the list box.How can I exclude other values from the lsit box ?

Thanks in advance.

Re: List box value limit.

Luis_Cortizo — Thu, 27 Feb 2014 17:47:28 GMT

There is no restrictions on the Listbox to show values beyond putting there an expression instead of a field. But that consumes resource innecesarily.

I'd create a new field on the MasterCalendar which would contain only those values (with a match or even an if statement) and use that field on the design layer.

Hope it helps.

Best regards.

Re: List box value limit.

MK_QSL — Thu, 27 Feb 2014 17:51:13 GMT

Write Down below expression in List Box Expression...

=IF(Year <= 2014 and Year >= 2010, Year)

Re: List box value limit.

rustyfishbones — Thu, 27 Feb 2014 17:54:05 GMT

Create a list box Expression

And Add this expression

IF(Year >= 2010 , Year)

Re: List box value limit.

Thu, 27 Feb 2014 17:55:25 GMT

AS suggested by Luis its best if done while scripting. I have done it in both ways.

Check out the attached.

Thanks

Re: List box value limit.

aveeeeeee7en — Thu, 27 Feb 2014 17:58:05 GMT

Use Where Condition

eg.

Master Calendar:

Load

Year,

Month,

Quaerter,

MonthName,

FiscalYear

From Abc.qvd

Where Wildmatch(Year,'2014','2103','2012','2011','2010');

Or you can create a field in the Table:

eg.

Master Calendar:

Load

Year,

Month,

Quaerter,

MonthName,

FiscalYear,

if(Wildmatch(Year,'2014','2103','2012','2011','2010'),Year) AS YearNewField

From Abc.qvd;