Using Where Len(Trim())>0 statement to eliminate null values

[jleefjcapital]

Hello,

I'm pulling time series data where it's listing out all of the dates regardless of whether there's a corresponding value.   I tried using the Where statement, len(trim())>0 in the data editor, but nothing's changing.  

LOAD

    Date#("date",'YYYY-MM-DD') AS DATE,

     value as AlabamaRGDP,

     value as [REAL GDP],

    'Alabama' as [STATE]

FROM [lib://Real Total Gross Domestic Product by State for Alabama]

(XmlSimple, table is [observations/observation])

WHERE len(trim(value))>0  ;

[jleefjcapital]

Hello,

Here's the file.  I found out that Qlik Sense files have the QVF extension.  Thank you!

[jleefjcapital]

Hello,

I just realized that Qlik Sense uses a different extension.  Here you go.

Thanks!

[jleefjcapital]

Krishna,

Qlik Sense uses a different extension- here you go!