topic Re: List box Expression in QlikView

List box Expression

Anonymous — Thu, 09 Jul 2015 00:53:28 GMT

I want to give a list box expression: If the values of age are 30 and 50, then show age.

It works when I write this expression : =if([Age]='30', Age)

How do I also include the value 50?

It throws an error when I try to write the expression : if([Age]={'30', '50'}, Age)

Thanks

Re: List box Expression

aveeeeeee7en — Thu, 09 Jul 2015 04:32:01 GMT

Use this Expression:

if(Match([Age],'30','50'), Age)

Regards
Av7eN

Re: List box Expression

maxgro — Thu, 09 Jul 2015 04:45:41 GMT

you can also use an or

=if(Age=30 or Age=50, Age)

Re: List box Expression

Anonymous — Thu, 09 Jul 2015 04:54:25 GMT

Hey,

This expression is not working.

Re: List box Expression

Anonymous — Thu, 09 Jul 2015 04:54:59 GMT

Thank You!

Re: List box Expression

maxgro — Thu, 09 Jul 2015 05:02:46 GMT

why not?

Re: List box Expression

jagan — Thu, 09 Jul 2015 05:45:27 GMT

Hi,

Try like this

If(Match(Age, 30, 50), Age)

If(Age = 30 OR Age = 50, Age)

The preferred method is using Match(), if you have more values then the length If() expression will become more. So best use Match().

Regards,

Jagan.

Re: List box Expression

Anonymous — Thu, 20 Aug 2015 18:17:25 GMT

Hi,

I have loaded thousand of records using Load script. I created a List Box and it shows all the thousand distinct values as below screen

Now i want filter and display only 6511001,6511002,7511001 and 7511006.

I went properties of list box and wrote the expression as below

I see the matching values besides the value and rest all not matched has '-'. I want to see only match values in the list box.

Please see below the values i see as :

I want to see only Matching value and rest all should be hidden.

Appreciate your help.

Regards,

Paul

Re: List box Expression

Thu, 20 Aug 2015 19:43:06 GMT

You can create LB Expression on drop down of your fields list. You can see <Expression> final field in the list.

Re: List box Expression

jagan — Fri, 21 Aug 2015 01:46:12 GMT

Hi Paul,

YOu need to write this expression in

Properties -> General-> Field -> Select <Expression> -> and give your expression there.

OR the best method is in script arrive a new column like below

LOAD

If(Match(FieldName), Num1, Num2, Num3), FieldName) AS NewFieldName

FROM Datasource;

Hope this helps you.

Regards,

jagan.

Re: List box Expression

Anonymous — Fri, 21 Aug 2015 02:36:03 GMT

Hi,

Use If(Match(Age, 30, 50), Age) it will work