topic define one WHERE statement for misc tables in QlikView

define one WHERE statement for misc tables

qlikhans — Wed, 31 Mar 2010 18:20:31 GMT

Suppose I have 3 tables, all containing amongst others a company name (fieldname is Company). I want to limit my output to one company: ' ABC'.

What I do now is for each of the tables I insert WHERE(Company='ABC'). Is it possible to make 1 WHERE statement that goes for all tables?

appreciate your response

Hans

define one WHERE statement for misc tables

sicilianif — Wed, 31 Mar 2010 18:40:17 GMT

One option is to use the current where clause for the first table, and for the other two use WHERE EXISTS(Company).

For the other two tables, it will only load records where the company exists.

Frank

define one WHERE statement for misc tables

Wed, 31 Mar 2010 19:07:03 GMT

You can define the where-statement in a varible that you use in all your 3 load-statements:

LET whereStatement = 'WHERE(Company=' & chr(39) & 'ABC' & chr(39) & ')'; 'chr(39) is the single quote character

LOAD * FROM myFile $(whereStatement);
LOAD * FROM mySecondFile $(whereStatement);
LOAD * FROM myThirdFile $(whereStatement);

/Fredrik

define one WHERE statement for misc tables

qlikhans — Thu, 01 Apr 2010 15:55:14 GMT

Hi Frank,

t.u. for your answer. It helps unexperienced programmers like me to learn the tricks of the trade.

define one WHERE statement for misc tables

qlikhans — Thu, 01 Apr 2010 15:56:40 GMT

Hi Fredrik,

As replied to Frank, I am learning to program on the fly, and comments like yours help me a lot