Qlikview Search from List Box

[Anonymous]

Greetings

I have  field named DESCRIPTION (Long sentence)

The field will be typically looks like as follows

Example 1:

HS 25 , 5% MARGIN , LONG PATTERN EMBEDDED , PACKED IN 2KGS

Example 2:

HS-25, 15% Margin, LONG, Packed in 25KGS

EXAMPLE 3:

HS25, 20% MARGIN, PACKED in 10KGS

EXAMPLE 4:

LONG PATTERN, PACKED in 50KGS

EXAMPLE 5:

PLAIN WHITE, PACKED  20KGS

EXAMPLE 6:

BROWN FINISH, PACKED 10KGS

The Key words are HS 25, HS-25, HS25 and LONG. I need to find all the fields in table which matches the KEY Words. Example 5 and 6 is not matching.

How do I implement?

Thanks

[Anil_Babu_Samineni]

Check there? Search ‒ QlikView

[Anonymous]

Thanks but it does not say I can search OR

Example I need to find values

'HS 25' OR  'HS-25'  OR  'HS25' OR 'LONG'

[Anil_Babu_Samineni]

Have you enable any search on your settings. This will work normally but Qlik always prefer double quotes. If you have * symbol delete that and use like below

"HS 25" OR "HS-25" OR "HS25" OR "LONG"

[Anonymous]

Thanks You mean associate Search?

My list box is more than 10000 fields. So while searching  "HS 25" OR "HS-25" OR "HS25" OR "LONG"

How to select All?

[Anil_Babu_Samineni]

No need to select Manually, If your filter correct just hit "Enter" it will associate to each and will display the number of values

[Anonymous]

Thanks Anil Babu. Appreciate.  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]

Here you go

LOAD

    FILED1,

    FILED2,

    FIELD3,

    DESC,

    FIELDX

FROM

(ooxml, embedded labels) where Match(DESC, "HS25", "HS 25" , "HS-25" ,"LONG"); // Or WildMatch(DESC, "HS*", "LONG") -- second condition works where starting DESC string is HS

Finally, You can do same you mentioned

LOAD

    FILED1,

    FILED2,

    FIELD3,

    DESC,

    FIELDX

FROM

(ooxml, embedded labels) Where DESC="HS25" OR DESC="HS 25" OR DESC="HS-25" OR DESC="LONG";

Note - Please don't create duplicate threads Re: How to click & Select from Qlikview List box Search findings

[Anonymous]

I have tried with one field.

LOAD

    FILED1,

    FILED2,

    FIELD3,

    DESC,

    FIELDX

FROM

(ooxml, embedded labels)where DESC="HS25";

It says Script error Field Not found - <HS25>

[eliran]

Hi Ram,

In qlikview, when you want to address a string in the ETL, you should use ' and not ".

So your syntax should look like this:

LOAD

    FILED1,

    FILED2,

    FIELD3,

    DESC,

    FIELDX

FROM

(ooxml, embedded labels)where DESC='HS25';

Regards,

Eliran.