Solved: Re: Need help in using IN function - Qlik Community - 459689

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

Hi,

Is it possible to use the IN fuction when loading a QVD.

When I try to use the IN function in the Where conditon its showing error.

Please advise...

Regards

Chriss

1 Solution

Accepted Solutions

Hi

The QV script equivalent is Match(), eg

Where City In ('Cape Town', 'Johannesburg', 'Harare')

codes in QV like this:

Where Match(City, 'Cape Town', 'Johannesburg', 'Harare')

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies

Hi

The QV script equivalent is Match(), eg

Where City In ('Cape Town', 'Johannesburg', 'Harare')

codes in QV like this:

Where Match(City, 'Cape Town', 'Johannesburg', 'Harare')

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Author

Excellent Jonathan,

It works......