List Box Query?

[MuraliPrasath]

Hi,

I need to list out only the data that starts from 'AB' in my list box. how to achieve this?

Need help!

[arulsettu]

if(wildmatch(PROD_HIER,'AB*'),PROD_HIER)

[avinashelite]

Try like this

=if(PROD_HIER like 'AB*',PROD_HIER)

[Anonymous · Accepted solution]

Hi,

Go to ListBox Properties --> Drill down Dimension to expression --> Write expression

If(left(PROD_HIER,2)='AB',PROD_HIER)

[surendraj]

In liastbox-->General-->field--->Expression-->edit--->

If(Trim(left(PROD_HIER,2)='AB',PROD_HIER)