Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

List Box Query?

Hi,

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

Need help!

Capture.PNG

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

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

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

1.JPG

View solution in original post

4 Replies
arulsettu
Master III
Master III

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

avinashelite

Try like this

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

Anonymous
Not applicable

Hi,

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

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

1.JPG

surendraj
Specialist
Specialist

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

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