Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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. 

2 Solutions

Accepted Solutions
Highlighted
Master II
Master II

Re: Particular field values retrive at a time

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

Highlighted
Master II
Master II

Re: Particular field values retrive at a time

try replacing the trigger with the below:

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

Best Regards,
KC

View solution in original post

8 Replies
Highlighted
Creator III
Creator III

Re: Particular field values retrive at a time

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.

Highlighted
Master II
Master II

Re: Particular field values retrive at a time

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

Highlighted
Creator II
Creator II

Re: Particular field values retrive at a time

Thank you so much Broo

Highlighted
Creator II
Creator II

Re: Particular field values retrive at a time

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

Highlighted
Master II
Master II

Re: Particular field values retrive at a time

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
Creator II
Creator II

Re: Particular field values retrive at a time

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

Highlighted
Master II
Master II

Re: Particular field values retrive at a time

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

1

2

3

4

 

Best Regards,
KC
Highlighted
Master II
Master II

Re: Particular field values retrive at a time

try replacing the trigger with the below:

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

Best Regards,
KC

View solution in original post