Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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