Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
madeleine_josef
Contributor

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
MVP & Luminary
MVP & Luminary

Re: Picking values

Try it with:

...

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

- Marcus

Re: Picking values

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

madeleine_josef
Contributor

Re: Picking values

That worked, thanks!