topic Re: Limiting the values in List Box in QlikView

Limiting the values in List Box

Tue, 04 Sep 2012 17:40:06 GMT

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:

>=15

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

Thanks,

Re: Limiting the values in List Box

pgalvezt — Tue, 04 Sep 2012 18:04:57 GMT

Hi, In your load script put:

Where FieldName > 15;

Re: Limiting the values in List Box

MayilVahanan — Tue, 04 Sep 2012 18:12:32 GMT

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

>15

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

If so, use like this, in script,

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

Just above > 15

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

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

Load * from table where FieldName > 15;

Hope it helps

Re: Limiting the values in List Box

Tue, 04 Sep 2012 18:15:51 GMT

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?

Re: Limiting the values in List Box

pgalvezt — Tue, 04 Sep 2012 18:25:46 GMT

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.

Re: Limiting the values in List Box

Tue, 04 Sep 2012 18:29:04 GMT

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

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

Re: Limiting the values in List Box

Tue, 04 Sep 2012 18:32:37 GMT

Hi Pgalvezt,

Thanks for reply.

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

Re: Limiting the values in List Box

pgalvezt — Tue, 04 Sep 2012 18:35:15 GMT

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

Re: Limiting the values in List Box

Tue, 04 Sep 2012 18:54:18 GMT

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?

Re: Limiting the values in List Box

MayilVahanan — Tue, 04 Sep 2012 18:57:02 GMT

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

Hope it helps

Re: Limiting the values in List Box

Tue, 04 Sep 2012 19:21:36 GMT

Mayil,

Thanks for your reply.

By using above expression I am getting the follwoing values in the listbox:

6, 7, 8, ....14, >=5<=15 and >=15

In fact I just want the following values in my list box:

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

I would highly appreciate if you write a expression for these values.

Thanks in advance.

Re: Limiting the values in List Box

MayilVahanan — Tue, 04 Sep 2012 19:27:41 GMT

Try this,

=if(test >= 5, '>=5<=14', if(test > 14, '>=15', test))

Hope it helps

Re: Limiting the values in List Box

pgalvezt — Tue, 04 Sep 2012 19:30:59 GMT

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

Re: Limiting the values in List Box

Tue, 04 Sep 2012 19:39:55 GMT

I am sorry its not.

Here is what I am getting here:

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

There is no value >=15

and If I select >=5<=14 result is not limited to 14 or less in fact it shows the reulst for more than 14 as well

Re: Limiting the values in List Box

Nicole-Smith — Tue, 04 Sep 2012 19:43:56 GMT

if(FieldName < 5, FieldName,

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

Re: Limiting the values in List Box

MayilVahanan — Tue, 04 Sep 2012 19:47:15 GMT

try this..

if(FieldName < 5, FieldName,

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

...

Re: Limiting the values in List Box

Tue, 04 Sep 2012 20:06:51 GMT

Now filter is shown correclty but Still the result is not coming out correctly.

Now I see the filters as

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

but when I have slected >=5<=14 some values are shown which are more than 14 as well.

Any clue why?

Thanks,

Re: Limiting the values in List Box

MayilVahanan — Tue, 04 Sep 2012 20:11:34 GMT

Did you use in script or expression? If you did in expression, try this in script for that particular field..

You may be get answer as you expected

Re: Limiting the values in List Box

Tue, 04 Sep 2012 20:22:20 GMT

You mean before loading the data?

under the relveant table...right?

Re: Limiting the values in List Box

MayilVahanan — Tue, 04 Sep 2012 20:27:14 GMT

Like this,

Load if(FieldName < 5, FieldName,if( FieldName <= 15, '>=5<=15', '>15')) as FieldName, *

from TableName;

Hope it helps