list box filtered

[selcukcadir]

hi all,

my table,

value1           valeu2

a              xx

a              yy

a              zz

b              tt

b              ff

c              kk

c              rr

my list box

I want to appear in

only value  <a>

value2

xx

yy

zz

How do I make it ?

All currently is ;

value2

xx

yy

zz

tt

ff

kk

rr

[#2]

so your value2 contains the ff:

xx

yy

zz

tt

ff

kk

rr

and you want your value2 only contain this:

xx

yy

zz

Is my understanding correct?

I don't know if there are simplier ways to do this, this is how you can do it with an if condition. when you create a list box on the 'field' value,

select expression. write an if statement what you want to filter.

if(value2='xx' or value2='yy' or value2='zz', value2)

[jagannalla]

Hello,

Right click on sheet -> New Sheet Object -> List Box -> Click drop down box of Field Section -> You will find <Expression> -> Click on it

In expresson paste this code =If(value1 ='a', value2)

Hope it helps you

Cheers!!

Jagan Nalla

[jagan · Accepted solution]

Hi,

Try this script

Temp:

LOAD * INLINE [

value1,valeu2

a,xx

a,yy

a,zz

b,tt

b,ff

c,kk

c,rr];

Test:

LOAD

    value1,

    valeu2 as valueA

Resident Temp

WHERE value1='a';

Now provide valueA as Listbox.  If you expression as Listbox it calculates everybox when selection changes.  So this is good practice.

Regards,

Jagan.