First of all i would like to say Hi to all of you guys as this is my first post and I'm quite new in this community. I don't have much experience in QlikView yet so It would be nice if some of you could help me.
I'm getting data from an OBDC connection and I need to apply a filter in one of the fields I'm loading. So that, I'm using a WHERE function after the "From" sentence.
The filter I need to apply is about getting data only when the values of this field doesn't start with 'BBOO' so I'm using a LEFT function together with the WHERE function.
It would be something like this: WHERE LEFT(XXXXXX,4) <> 'BBOO'; but it doesn't work. I guess I'm making a mistake on the syntaxis but I'm not able to identify where.