Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

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

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

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

Load

          Field1,   

          Field2

From <> Where Field1> 100;

3 Replies
sushil353
Honored Contributor II

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

Check this out: Video Link : 4112

HTH

MVP
MVP

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

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

Load

          Field1,   

          Field2

From <> Where Field1> 100;

datalakeyu
Valued Contributor

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

Thanks tresesco,

It works.

LOAD

  [column1],

  [column2]

FROM <>

Where [column1]=1;