Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Pujitha
Contributor II
Contributor II

Search Values

The input table file has columns as ID in which we have 2000 and more id's. So the requirement is the user has able to select 1000 or more than those cases at a time. like (OR Search) id1,id2,id3.....id1000 at a time  in search box but all the ids are not displaying in current selection box till id 45 or something after if you copy(search)id's at a time  it is not showing up in current selection box and straight table is not reacting according to the ids what we are searched in the straight table. So, I tried by using the input box with some variable in that also I am unable to search (like copy id values from input excel  file at least 100 id's) ids I try to copy in the INPUT BOX (by using  some variable(Vsear) )but it is not accepting after 45 or some number at a time. Even, in current selection box it is showing only 45 or something and the straight table is not reacts.Please suggest me good solution for this as I am trying it from so long.Thanks!!

4 Replies
chrismarlow
Specialist II
Specialist II

Hi,

Have you tried advanced search;

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Advanced_Search.htm

On the IE plug-in I remember putting together lists that were very long on this (100's if not 1000's of elements) & it did work.

Cheers,

Chris.

jonathandienst
Partner - Champion III
Partner - Champion III

There is a size limit on pasting into a search box for a list box (255 characters - I think)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
chrismarlow
Specialist II
Specialist II

Hi, what I am thinking of is the advanced search dialog box that comes up as a right click option. Will try to find a screenshot.
Cheers,
Chris.
chrismarlow
Specialist II
Specialist II

Like this;

20190312_1.png