Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (2)
2 Replies
mhaferkamp
Partner - Contributor II
Partner - Contributor II

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);