topic Re: display/search values with pretended filter in QlikView

display/search values with pretended filter

Wed, 18 Jun 2014 07:13:57 GMT

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";

tresB — Wed, 18 Jun 2014 07:18:42 GMT

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 — Wed, 18 Jun 2014 07:21:15 GMT

Might need to be

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

if you are using SQL Server

tresB — Wed, 18 Jun 2014 07:29:20 GMT

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