Limiting the values in List Box

[#1]

Hi All,

If some one can answer this question and help me out, my life will become very very easy.

I have a list box which has values from 0 to 100

For my reporting purpose I just need values which are greater 15

If I use default list box then user has to always select values which are greater 15 manually every time.

Is there a way that I can make a list box which show values like this:

0

1

2

3

.

.

.

14

>=15

Plesae reply if there is any way or any other way/object which can handle this requirement.

Thanks,

TA

[pgalvezt]

Hi, In your load script put:

Where FieldName > 15;

[MayilVahanan]

Hi

     I have a doubt? You want to show your list box like this,

0

1

2

3

.

.

14

>15

or

only greater than 15? and for that list box oly??

If so, use like this, in script,

if(FieldName > 15, '>15', FieldName) as FieldName;

or

Just above > 15

if(FieldName > 15, '>15') as FieldName;

Or you want whole field above 15 only, use where condition..

Like

Load * from table where FieldName > 15;

Hope it helps

[#4]

Thanks for your reply.

Is there any other way of doing this? In fact I have to create one more report for

> 5 as well. If I write FieldName> 15 in load script, then I cannot filter it for > 5...right?

[pgalvezt]

You can create like Mayil said

if(FieldName <= 5, '>=5', FieldName) as <=5;

if(FieldName > 15, '>15', FieldName) as >15;

and so on and then call the differents fields in QlikView.

[#6]

In your list box <expression> as your field and put your expression in there.

=

IF(FieldName<16,FieldName,Null())

[#7]

Hi Pgalvezt,

Thanks for reply.

Do you want me to write this in load statement of or in Listbox expression?

[pgalvezt]

In Script. so should be have many list box with differents selections.

[#9]

Hi,

I am sorry I did not get this.

In fact I just updated my list box expression and now I can see listbox with following values:

0,1,2,3,4,>=5 which is perfect for one of my list box.

Now for other one I need values in the list box as

0,1,2,3,4, >=5<=15, > 15

I probably need if and then else if conditon...right?

These both worked perfectly in list box expression

if(FieldName <= 5, '>=5', FieldName) as <=5

if(FieldName > 15, '>15', FieldName) as >15

but how can i write else if condtion?

,

[MayilVahanan]

Hi

if(FieldName <= 5, '>=5<=15', if(FieldName > 15, '>15', FieldName)

Hope it helps