topic Re: mutilple search string from field through input box in QlikView

mutilple search string from field through input box

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

My application has a input box as search box.

i have a field called "Category ID"

Category ID	Rank
US0071243	5
US0062711	3
AE1212121	2
AC0000121	3
CA1201921	3
IN12121211	4

My Question - i want to type any of the available string (category ID) in the input box, For Eg. US00*,AE00* then my straight table should bring both the combinations of Id's,

like this.

Category ID	Rank
US0071243	5
US0062711	3
AE1212121	2

In Input box i am using variable as vSearch and In Settings -> Document Properties -> Triggers -> Variable Event Triggers -> vSearch

->OnChange -> action as 'select in filed' -> in Field ( i am using Category ID) and in Search String ( i am using "=if(Len(vSearch)>0,'*|'& vSearch & '|*','')" )

by using this i am able to search single category Id, but if i am using replace i am unable to search multiple search.

Kindly help me asap.

Thanks in Advance.

Yours

Venkat

Re: mutilple search string from field through input box

sunny_talwar — Mon, 13 Feb 2017 13:16:09 GMT

but if i am using replace i am unable to search multiple search.

Using replace?

Re: mutilple search string from field through input box

Anonymous — Mon, 13 Feb 2017 13:28:55 GMT

Why don't you just use a Listbox and fill with a search string like that?:

(US00*|AE00*)

for example?

Re: mutilple search string from field through input box

Mon, 13 Feb 2017 14:31:07 GMT

Hi Sunny, Thanks for reply... Can you send me the expression.

Re: mutilple search string from field through input box

sunny_talwar — Mon, 13 Feb 2017 14:33:53 GMT

I am still not sure what you are looking to get. May be try roharoha‌'s response?

Re: mutilple search string from field through input box

Mon, 13 Feb 2017 14:34:21 GMT

Hi Robin, Thanks for reply.. I don't want to change it to list box.. its already developed dashboard and In home page only we are providing the search option. based on the search only the resultant dashboard will shown to the user.. can you try it in input box only.. thanks for your suggestion.

Re: mutilple search string from field through input box

Mon, 13 Feb 2017 14:39:14 GMT

i will post my sample qvw file soon.. so that you can understand..

Re: mutilple search string from field through input box

sunny_talwar — Mon, 13 Feb 2017 14:43:46 GMT

Sounds good

Re: mutilple search string from field through input box

german24 — Mon, 13 Feb 2017 15:46:50 GMT

I hope help you whit this,

//Create a Category for each "Category ID" and you will can used that field

Category:

LOAD Distinct

[Category ID],

Left([Category ID],2) AS Category //New field (contains for example: 'US', 'AE')

Resident Tabla; //Where is the field "Category ID"

Best regards,

German

Re: mutilple search string from field through input box

Anonymous — Mon, 13 Feb 2017 16:24:37 GMT

... select in field:

='("$(=Replace('$(INPUT)',',','"|"'))")

Re: mutilple search string from field through input box

Mon, 13 Feb 2017 16:57:30 GMT

Thanks Robin, It seems to be correct. but when i am try in my qvw file the expression showing error. Can take same example and upload the qvw file. so that i can get it clear understand about it.. Lots of thanks for your help.

Re: mutilple search string from field through input box

Anonymous — Mon, 13 Feb 2017 17:03:27 GMT

just test it with a text box,

the parser won't "understand" such strange expressions.

A textbox is a good idea for debugging I think.

Re: mutilple search string from field through input box

Mon, 13 Feb 2017 17:09:30 GMT

i am testing in text box only..but i am getting expression error, when i am using this expression ='("$(=Replace('$(INPUT)',',','"|"'))").

Re: mutilple search string from field through input box

Mon, 13 Feb 2017 17:11:34 GMT

i am happy if you upload qvw file with your solution.

Re: mutilple search string from field through input box

Anonymous — Mon, 13 Feb 2017 17:14:41 GMT

I have uploaded it yet!

Re: mutilple search string from field through input box

Wed, 15 Feb 2017 15:05:26 GMT

HI All,

Sorry for the delay to response.. Now i am uploading with my original search and required search.

I need to search multiple in all the search. where ever i need.

Please find the attachment for more clarification..

Kindly help me.. Thanks in advance.

Re: mutilple search string from field through input box

Wed, 15 Feb 2017 15:11:53 GMT

HI Sunny,

Now uploaded qvw file and excel file with data.

Can you help me.

Re: mutilple search string from field through input box

Wed, 15 Feb 2017 15:13:26 GMT

Hi Robin,

sorry for the delay, now i uploaded qvw file and excel file with data which i need. your expression is not working for me.

Thanks in advance.

Re: mutilple search string from field through input box

sunny_talwar — Wed, 15 Feb 2017 16:27:52 GMT

Still trying to understand how the multiple search will work? If you search something, it should find matches in SAID or _SearchStr?

Re: mutilple search string from field through input box

Anonymous — Wed, 15 Feb 2017 17:17:47 GMT

for your example, the values depend on each other, so if you select the above, you'll get only the rest with the second selection, this could be desired or not... I don't know