Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
assadandre
Contributor
Contributor

using "Between" and "is not null" in load editor from a QVD

Good Day,

Can anyone advise if there is any way to use "Between" and "is not null" functions in the load editor when loading data from a QVD?

and if yes, how?

Thanking you in advance.

Best regards,

Labels (3)
2 Replies
mhaferkamp
Partner
Partner

Hi Assadandre,

If you need a function like between in the where statement use the following syntax:

Load
    FieldA,
    FieldB,
    -------
From ----------------
where Date >= makedate(2019, 1, 1) and Date <= today();

Please make sure that your date in your dataset doesn't contain a timestamp. This could help you: Date and time functions

In my opinion the best solution to find empty or filled cells is the following where statement. You can combine it with the where statement before (AND operation).

where len(trim(FiledName)) > 0;

I hope I was able to help you. Best regards,

Marius.

Marcos_rv
Creator II
Creator II

LOAD

...

...

...

 

FROM ...

where not isnull(ALGO);