WHERE FUNCTION

GerardQR92 — Sat, 16 Nov 2024 21:31:03 GMT

Hi Qlik adicts!

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.

I've just added a screenshot showing the script.

I would be glad if some of you could help me.

Many thanks guys!!

Re: WHERE FUNCTION

sstroop — Mon, 28 Jan 2019 19:43:40 GMT

Hi, Gerard,

Try using the wildmatch function:

where not wildmatch(Field,'BBOO*')

Re: WHERE FUNCTION

sstroop — Mon, 28 Jan 2019 19:45:53 GMT

Sorry - just saw the screenshot - move your where function up to the load part of the script prior to adding wildmatch.

topic Re: WHERE FUNCTION in QlikView

WHERE FUNCTION

Re: WHERE FUNCTION

Re: WHERE FUNCTION