Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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