Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is it possible to use Where clause in the Load part with Qlik sense?

Is it possible to use Where clause in the Load part (not in the SQL Select part) with Qlik sense?

Any suggestion is appreciated!

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Yes. It's  simple and similar like in SQL Select:

Load

          Field1,   

          Field2

From <> Where Field1> 100;

View solution in original post

3 Replies
sushil353
Master II
Master II

Check this out: Video Link : 4112

HTH

tresesco
MVP
MVP

Yes. It's  simple and similar like in SQL Select:

Load

          Field1,   

          Field2

From <> Where Field1> 100;

Anonymous
Not applicable
Author

Thanks tresesco,

It works.

LOAD

  [column1],

  [column2]

FROM <>

Where [column1]=1;