Discussion board where members can get started with Qlik Sense.
I've a table like this (this is a fake one):
How I can filter all the string on column1 that does not contain "x"?
I've tried so far the opposite, like:
where column1 like '%x%';
But first it does the opposite that I want (I do not want the ones with the x), furthermore it does not work. Have you already done something like this before?
Thanks in advance
WHERE NOT column1 LIKE '*x*';
View solution in original post
Hi simotrab, try this... in the load script.
Tell us if it's fine.
First of all this works perfectly, thanks. Why it seems not working for "ac" for example (not important "a" and "c" , but "ac")?
It's work fine , with ..:
sampleTable:load*Inline[column1, colunm2axc, 1ac,2axd,3azx,2az,1a,1]where not column1 like '*ac*';