Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In your data the values are not separate values. Can you try like below
Load * from Table Where WildMatch(DESC, '*HS*','*LONG*');
Check there? Search ‒ QlikView
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'
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"
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?
No need to select Manually, If your filter correct just hit "Enter" it will associate to each and will display the number of values
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
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
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>
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.