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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Picking values

Hi,

I have a file called receipt.qvd where I have the value Account. How can I choose to only include the following accounts:

3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649.

Thanks!

3 Replies
marcus_sommer

Try it with:

...

where match(Account, 3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649);

- Marcus

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

You should use where condition, like below.

Load * from Receipt.qvd where match(Account,3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649);

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

That worked, thanks!