topic Re: select where id in list in QlikView

select where id in list

Fri, 07 Mar 2014 12:00:08 GMT

Hi,

I've a select statement of the following syntax:

Table:

load *

from table.qvd

where id = 1 or 2 or 3;

Because the list of applicable IDs is considerably long I'd like to simplify the statement to something like

Table:

load *

from table.qvd

where id in IDlist;

Any ideas on how to achieve this?!

Re: select where id in list

MK_QSL — Fri, 07 Mar 2014 12:02:27 GMT

Where Exists (IDlist, ID)

Where IDlist is a table like below

Load * Inline

[

IDlist

];

Re: select where id in list

tresB — Fri, 07 Mar 2014 12:02:51 GMT

Exists() ?

Re: select where id in list

Fri, 07 Mar 2014 12:03:30 GMT

might be you can use

where Id >=1 and <=50

if its in sequence!

Re: select where id in list

Fri, 07 Mar 2014 12:13:12 GMT

Hi Manish,

this is exactly what I was looking for!

Now instead of using inline tables I'll look if I can just import the relevant ID's from my source files.

Thanks a bunch!

Re: select where id in list

Fri, 07 Mar 2014 12:53:16 GMT

Hi Manish,

one more question.. although the script runs..

the Where Exists(IDlist, ID) statement doesn't yield the return that

where id = 1 or 2 or 3 does...

In fact it seems the exists function doesn't find any matches?

Re: select where id in list

MK_QSL — Fri, 07 Mar 2014 12:58:46 GMT

Try this sample..

Load * Inline

[

IDList

];

Load * Inline

[

Customer, ID

A, 1

B, 2

C, 3

D, 4

E, 5

F, 6

]

Where Exists (IDList, ID);

Drop Field IDList;