Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Surya
Creator II
Creator II

Particular field values retrive at a time

Hi,

I Have an a field,on that field i have 1000 records for example 1-1000.

when i want multiple values to select at a time just drag and drop and randomly selected values purpose we need to check one by one.

but my user want hey need some input box on that he just pasted the values and automatically retrive all matching values.

i.e., 1,4,13,67,234,655,6789

 

these values pasted into particular input box then he retrive all the related data.

 

Thanks. 

Labels (2)
2 Solutions

Accepted Solutions
jyothish8807
Master II
Master II

Hi Prakash,

 

Check the attached, hope this is what you want:

I just created Select in filed trigger for variable vSearch:

 

Best Regards,
KC

View solution in original post

jyothish8807
Master II
Master II

try replacing the trigger with the below:

='('&Replace(trim(vSearch),' ','|')&')'

Best Regards,
KC

View solution in original post

8 Replies
arpitkharkia
Creator III
Creator III

if they search in the following way,

(1) | (4) | (13) | (67) | (234) | (655) | (6789)

in the search option of a list box.

 

I hope this helps and makes sense.

jyothish8807
Master II
Master II

Hi Prakash,

 

Check the attached, hope this is what you want:

I just created Select in filed trigger for variable vSearch:

 

Best Regards,
KC
Surya
Creator II
Creator II
Author

Thank you so much Broo

Surya
Creator II
Creator II
Author

Bro.,

Thank you for that.but as my requirement we need directly copy from excel into our application.please give me some solution for that also

jyothish8807
Master II
Master II

You can always copy paste data from excel as well, Just make sure the data in this format:

1,3,4,5

else let me know how it will be copied.

 

Best Regards,
KC
Surya
Creator II
Creator II
Author

We are giving detailed charts all the cases for users.

users directly taken send to excel or those are already having all the field values.

so now we need to copy data from excel and directly pasted in a input box.

 

 

 

Thanks 

SP

jyothish8807
Master II
Master II

So you are going to copy the text at row level ? Like below :

1

2

3

4

 

Best Regards,
KC
jyothish8807
Master II
Master II

try replacing the trigger with the below:

='('&Replace(trim(vSearch),' ','|')&')'

Best Regards,
KC