Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ift_isabelle
Contributor II

Do not load when empty

Hi,

I have a dataset which has a total at the end.

I don't want to load it into my dataset.

How can I do that?

DateValueRemark
21/6/20165This is the data i want to load
20/6/20164This is the data i want to load
19/6/20163This is the data i want to load
This is an empty row which i want to delete
12This is the total row, which i don't want to load

I tried:

LOAD

     'Source1' As Source,

     [date],

     Value

FROM [lib://location.xlsx]

(ooxml, embedded labels)

Where [date] <> '';

Please help!

Thanks in advance,

Isabelle

Tags (2)
1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor III

Re: Do not load when empty

You could try

WHERE Len(Trim([date])) > 0

2 Replies

Re: Do not load when empty

Try     Where [date] > '';

marcus_malinow
Valued Contributor III

Re: Do not load when empty

You could try

WHERE Len(Trim([date])) > 0

Community Browser