topic where condition in QlikView

where condition

sushil353 — Fri, 08 Apr 2011 11:03:29 GMT

hi experts

i want to aply where condition while loading data from a xl file

TEAM:

LOAD

TEAM_ID,

[TEAM NAME],

[TEAM COST]

FROM

[..\TESTDATAFILE.xls]

(

biff, embedded labels, table is Sheet1$);

i tried to apply where team_id>20 after from [..\TESTDATAFILE.xls]. but it is giving me error.

please help me.

thanks.

Fri, 08 Apr 2011 11:47:25 GMT

Hi Sushil353

Try like this..

LOAD

TEAM_ID,

[TEAM NAME],

[TEAM COST]

FROM

(biff, embedded labels, table is Sheet1$)

Where Team_Id>20;

Otherwise, after written while reloading you can put filter.

[..\TESTDATAFILE.xls]

Fri, 08 Apr 2011 11:55:35 GMT

dont read my first post. it was stupid due to qlikview editor.

try this..

LOAD

EnqID

Insys_Status

FROM

[Sample Data.xls]

(

biff, embedded labels, table is [CCP CAll Status$]

)

where

EnqID >20;