Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
vishwa_461
Contributor III
Contributor III

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)

vishwa_461
Contributor III
Contributor III

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

surendraj
Specialist
Specialist

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

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