topic Re: List Box Query? in QlikView

List Box Query?

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Need help!

arulsettu — Thu, 09 Feb 2017 10:43:26 GMT

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

avinashelite — Thu, 09 Feb 2017 10:45:56 GMT

Try like this

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

Anonymous — Thu, 09 Feb 2017 10:47:28 GMT

Hi,

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

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

surendraj — Thu, 09 Feb 2017 10:52:58 GMT

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

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