Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

Re: display/search values with pretended filter

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
3 Replies
MVP
MVP

Re: display/search values with pretended filter

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

MVP
MVP

Re: display/search values with pretended filter

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
MVP
MVP

Re: display/search values with pretended filter

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

Community Browser