topic WHERE STATEMENT in QlikView

WHERE STATEMENT

Tue, 24 Aug 2010 13:30:57 GMT

Hi i am wondering if anyone can help, here is what i have so far and it works,

OverViewShopOrders:

LOAD

SHOP_ORD_NO,

PART_NO,

PART_DESCRIPTION,

PROJECT_ID,

FROM

[$(FolderPath)\]

FROM

[$(FolderPath)\]

FROM

[$(FolderPath)\]

qvd

)

WHERE

PROJECT_ID = 'S07050720' ;

But i would like for the WHERE PROJECT_ID = 'S07050720' , ' S07050721 ' ;

I only want to display the two fields but an error message keeps coming up when i enter this, Any suggestion please.

Thanks

WHERE STATEMENT

suniljain — Tue, 24 Aug 2010 13:34:43 GMT

Pls Try This Code

OverViewShopOrders: LOAD SHOP_ORD_NO, PART_NO, PART_DESCRIPTION, PROJECT_ID, FROM [$(FolderPath)\] FROM [$(FolderPath)\] FROM [$(FolderPath)\] qvd ) WHERE PROJECT_ID = 'S07050720' or PROJECT_ID = 'S07050721' ;

WHERE STATEMENT

nicole — Tue, 24 Aug 2010 13:35:21 GMT

Hi,

try this:

where PROJECT_ID='S07050720' or PROJECT_ID='S07050721' ;

Nicole

WHERE STATEMENT

Tue, 24 Aug 2010 13:35:50 GMT

You can try the OR between the two values:

WHERE PROJECT_ID = 'S07050720' OR PROJECT_ID=' S07050721 ' ;

WHERE STATEMENT

Miguel_Angel_Baeyens — Tue, 24 Aug 2010 13:36:51 GMT

Hello Kelly,

Check

OverViewShopOrders:LOAD SHOP_ORD_NO, PART_NO, PART_DESCRIPTION, PROJECT_ID FROM FILE.QVD (qvd) WHERE MATCH(PROJECT_ID, 'S07050720', 'S07050721') > 1

Check as well that variable "FolderPath" has the complete path to the file.

Hope that helps

WHERE STATEMENT

Tue, 24 Aug 2010 13:42:23 GMT

Yes the following code worked

Project_ID = 's07050720' or Project_ID = 's07050721'

Thanks very much