topic Re: How to click & Select from Qlikview List box Search findings in QlikView

How to click & Select from Qlikview List box Search findings

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

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

lironbaram — Mon, 26 Jun 2017 04:53:45 GMT

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

Anonymous — Mon, 26 Jun 2017 05:13:34 GMT

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 — Mon, 26 Jun 2017 05:20:38 GMT