Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

no load data that starts with a tilde?

What where statement can I use to not load data that starts with a tilde?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: no load data that starts with a tilde?

Where NOT Left(SourceName,1) = '~'

7 Replies
Gysbert_Wassenaar
Not applicable

Re: no load data that starts with a tilde?

Where NOT Left(SourceName,1) = '~'

Not applicable

Re: no load data that starts with a tilde?

Thank you it works great.

rbecher
Not applicable

Re: no load data that starts with a tilde?

‌Please mark the right answer as "right answer", not yours!!

Not applicable

Re: no load data that starts with a tilde?

Sorry about that but not sure how to uncheck the wrong correct answer and check the correct one?

Not applicable

Re: no load data that starts with a tilde?

Hi Gysbert,

I also have a similar problem in my case i don't want "undefined" data from my filter , i just altered your code above but am getting error, Please see the attached screenshot. can u help me on this?not able to get the desired output.PNG

Gysbert_Wassenaar
Not applicable

Re: no load data that starts with a tilde?

A Where clause can't be used in a chart expression, only in load statements in the script.

And "undefined" is 9 characters long, not 1. So you need to use 9 as the second parameter in the Left function.

Not applicable

Re: no load data that starts with a tilde?

Thank you Gysbert !!