Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Jammuk
Contributor
Contributor

Load more than 1 specific value

Hi all, brand new user here. I have the following script.

LOAD:
     FINANCIAL_YEAR,
     AMOUNT
FROM
(qvd)

WHERE FINANCIAL_YEAR  =  '2020-21'

;

How do I update it to load both 2020-21 and 2019-20?

Labels (1)
1 Solution

Accepted Solutions
arulsettu
Master III
Master III

may be like this

 

LOAD:
     FINANCIAL_YEAR,
     AMOUNT
FROM
(qvd)

WHERE Match(FINANCIAL_YEAR , '2019-20' ,'2020-21')

View solution in original post

3 Replies
arulsettu
Master III
Master III

may be like this

 

LOAD:
     FINANCIAL_YEAR,
     AMOUNT
FROM
(qvd)

WHERE Match(FINANCIAL_YEAR , '2019-20' ,'2020-21')

Jammuk
Contributor
Contributor
Author

Yes, that did it! Thank you!

arulsettu
Master III
Master III

please mark it as correct answer