Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Forum,
I got 2 fields in sam table,
Data 1 (is an Article)Data 2 (Is a freetext)
And then a got a table in Qlik
If Data 1 contains text "N2332" and Data 2 contains text "N2332" then i will present all the post contains this.
Example;
So when i search in this new (Data1 (Art) and Data2 (Freetext)) i want all the hits when a search on this word N2332 above.
Doable?
Hi thanx!
Is this inline must be there?MapText:// Mapping tableMappingLoad Code,'{' & Flag & '}' as MapTextInline [Code, FlagN2332, 1];
do you have any table that stores the Codes? where are you storing 'N2332'?
Come from same xls file and could be other values aswell. The code i don't have.
How would the App understand it? so we got to tell/write that explicilty. just like we did it in inline table.
Hmm, sorry. I just want to get hits to my table results from both Art and Freetext if it's conains a searchword that i type.
so you want to have a search box on front end and search a keyword and you should be able to see all fields that has that key word in ti?
Yes sir 🙂
then you dont need to all the above scripting, just type ~N2332 or ^N2332 or *N2332* (Wild Search)in the search box.
check below for all the tyes of searches:
https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Selections/SelectionsTool...
But can i search in 2 colums at the same time?
the search shows all the columns where that code is present.
you need to adjust the settings on what need to shown and what now.
