Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Edyta
Contributor III
Contributor III

Why does filter 'where' not work

Hi guys,

It must be easy but I cannot figure it out.

I have straight table data with columns: client, month, production cost, raw material cost.

My code is as below:

[JohnLewis]:
Load
*
resident RawData
where Match([Client], 'John Lewis');

drop table RawData;

After loading data, table RawData is loading, the filter does not work. Could you assist?

Labels (2)
1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi Edyta,

What you want is the following:

[JohnLewis]:
Load
*
resident RawData
where Client = 'John Lewis';

drop table RawData;

Because Match is now returning you 1 and it not filtering.

Jordy

Climber

Work smarter, not harder

View solution in original post

6 Replies
JordyWegman
Partner - Master
Partner - Master

Hi Edyta,

What you want is the following:

[JohnLewis]:
Load
*
resident RawData
where Client = 'John Lewis';

drop table RawData;

Because Match is now returning you 1 and it not filtering.

Jordy

Climber

Work smarter, not harder
Edyta
Contributor III
Contributor III
Author

I have tried it previously and this does not work too. I cannot also filter in other apps. No idea why.

Edyta
Contributor III
Contributor III
Author

It's like qlik does read filter and do not drop table RawData.

RawData is loading in full.

JordyWegman
Partner - Master
Partner - Master

Hmm what is exactly the problem now? That you don't get the John Lewis files or that the RawData table is still there?

Jordy

Climber

Work smarter, not harder
Edyta
Contributor III
Contributor III
Author

I solved it! there was a problem with loaded data.

Thank you for your engagement.

florentina_doga
Partner - Creator III
Partner - Creator III

noconcatenate
[JohnLewis]:
Load
*
resident RawData
where Match([Client], 'John Lewis');

drop table RawData;