Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
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
MVP & Luminary
MVP & Luminary

Re: no load data that starts with a tilde?

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


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
MVP & Luminary
MVP & Luminary

Re: no load data that starts with a tilde?

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


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Re: no load data that starts with a tilde?

Thank you it works great.

MVP & Luminary
MVP & Luminary

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

MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand
Not applicable

Re: no load data that starts with a tilde?

Thank you Gysbert !!