Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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