Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

WHERE STATEMENT

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

5 Replies
suniljain
Master
Master

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' ;

nicole
Contributor II
Contributor II

Hi,

try this:

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

Nicole

Not applicable
Author

You can try the OR between the two values:

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

Miguel_Angel_Baeyens

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

Not applicable
Author

Yes the following code worked

Project_ID = 's07050720' or Project_ID = 's07050721'

Thanks very much