topic Particular field values retrive at a time in QlikView

Particular field values retrive at a time

Surya — Sat, 16 Nov 2024 21:01:10 GMT

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.

arpitkharkia — Fri, 19 Apr 2019 08:05:48 GMT

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 — Fri, 19 Apr 2019 08:28:45 GMT

Hi Prakash,

Check the attached, hope this is what you want:

I just created Select in filed trigger for variable vSearch:

Surya — Sat, 20 Apr 2019 11:14:37 GMT

Thank you so much Broo

Surya — Sat, 20 Apr 2019 12:05:11 GMT

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 — Sun, 21 Apr 2019 11:35:32 GMT

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.

Surya — Mon, 22 Apr 2019 03:35:25 GMT

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

jyothish8807 — Mon, 22 Apr 2019 06:16:15 GMT

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

jyothish8807 — Mon, 22 Apr 2019 06:22:34 GMT

try replacing the trigger with the below:

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