Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to click & Select from Qlikview List box Search findings

I have a list box which contains nearly 10000 lines of data

When I do search "HS25" OR "HS 25" OR "HS-25" OR "LONG" I  get nearly 1000 lines of data in Listbox.

How do I click and select these?

Clicking Control Key + One by one from list box is very tedious job.

Thanks

3 Replies
lironbaram
Partner - Master III
Partner - Master III

after the search just click "enter" and the selection of the value that came up in the search will be made

Anonymous
Not applicable
Author

Thanks

I think My version do not work well. I am using version 12.0.20200.0 SR3

While entering "HS25" OR "HS-25" OR "HS 25" I can see new UI "Filter Search" by on the side.

But upon clicking enter , Filter Search by dialog goes and entire contents of list box is selected (not from my search specific).It may be some bug.

So best option is I should load using Load statement

Here is my Load Statement

LOAD

    FILED1,

    FILED2,

    FIELD3,

    DESC,

    FIELDX

FROM

(ooxml, embedded labels);

I need to add a statement as follows

Where DESC="HS25" OR DESC="HS 25" OR DESC="HS-25" OR DESC="LONG"

Where should I insert above the statement? Is my statement correct?

Thanks

Anil_Babu_Samineni

Don't create duplicate thread Re: Qlikview Search from List Box

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful