Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display/search values with pretended filter

Hi

my first question is about the simply search funktion.

While I have connected to my database, I have many IDs:

How can I search like: ID500***<X<ID600***

X is my search filter, so I want to show up all IDs from ID500*** to ID600*** - for selecting them

My second question is about to use the filter in the Script:

I work mostly with the database, so i can only read.

How can I use the filter in the Script  for selecting pretended values ?

CONNECT TO Database1;

load "ID",

     "Name",

     "Birthday";

    

SQL SELECT *

FROM "Database1".db1."Customer";

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Might need to be

Where "ID" Like 'ID500%' or "ID" Like 'ID600%'

if you are using SQL Server


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

View solution in original post

3 Replies
tresesco
MVP
MVP

Try like:

CONNECT TO Database1;

load "ID",

     "Name",

     "Birthday";

  

SQL SELECT *

FROM "Database1".db1."Customer"  Where "ID" Like 'ID500%' or "ID" Like 'ID600%';

Update: Corrected

jonathandienst
Partner - Champion III
Partner - Champion III

Might need to be

Where "ID" Like 'ID500%' or "ID" Like 'ID600%'

if you are using SQL Server


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
tresesco
MVP
MVP

Righ, just missed that. QV is in mind . Thanks Jonathan for the correction.