topic How to apply Where Clause to entrie Load script ? in QlikView

How to apply Where Clause to entrie Load script ?

Wed, 21 May 2014 16:04:44 GMT

Hi,

I am new in the qlikview world.

I am coming from the SQL background.

how can we apply where caluse to entire results ?

Example for SQL :

select

a.*

from A

left join

A.field = B.field

where

A.field = 'abcd <---how can we implement same thing in qlikview Load Script ?

any help would be appreciated, i am new in qlikview.

Re: How to apply Where Clause to entrie Load script ?

Anonymous — Wed, 21 May 2014 16:24:26 GMT

Hi we can use the where clause to load the data for

LOAD Year,

Month,

Sales,

EmpId,

makedate(Year,Month,1) as date_con

FROM

(ooxml, embedded labels, table is Sheet1) where Year='2013';

The above table load the data of perticular year 2013 Only.......

Re: How to apply Where Clause to entrie Load script ?

its_anandrjs — Wed, 21 May 2014 18:01:51 GMT

In Qlikview you have to try with

TableA;

Load *

From LocationA

Where field = 'abcd';

Left Join

TableB:

Load *

From LocationB;

Hope this helps

Re: How to apply Where Clause to entrie Load script ?

maxgro — Wed, 21 May 2014 19:21:50 GMT

you can use your sql in Qlikview; so another answer could be

Table:

load

field,

field2,

field3;

sql

select

a.field, a.field2, b.field3

from A

left join

A.field = B.field

where

A.field = 'abcd'

;

Re: How to apply Where Clause to entrie Load script ?

Thu, 22 May 2014 18:28:58 GMT

Example :

Noconcatanate:

Test:

LOAD *

Resident Table1: <---1000 records

Left Join

LOAD *

Resident Table2; <---300 records

Left Join

LOAD *

Resident Table3 <---Total 200 records among that 100 records has field 'abc'

Where Table3.field = 'abc'

so, end results , i was expecting to be 100 records ,

but, still getting 1000 records.

it looks like WHERE clause is applying to Table3 only and due to left join,

it returns 1000 reords and WHERE condition is not considering.

basically,

I want to apply that WEHRE clause entire results.

Re: How to apply Where Clause to entrie Load script ?

maxgro — Thu, 22 May 2014 18:58:37 GMT

yes where is on Table3

try to add

Final:

noconcatenate lod * resident Test where field = 'abc';

drop table Test;