Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Where Condition in SAP

Hi Guys

I am pulling the Data from BranchMaster.

I do not want to pull the data where Branch Code Starts with CT.

So i write the following script;

Load * ;

SQL VKBUR,BEZEI From TVKVT

Where VKBUR <> 'CT*';

But It is not Filtering out ..

4 Replies
Not applicable

Re: Where Condition in SAP

TRY THIS

Load * ;

SQL VKBUR,BEZEI From TVKVT

Where VKBUR != 'CT*';

Not applicable

Re: Where Condition in SAP

Not working giving Error

Not applicable

Re: Where Condition in SAP

try this

Load * ;

SQL  select   VKBUR,BEZEI From TVKVT

Where VKBUR != 'CT*';

*************************************************

try this

Load * ;

SQL  select   VKBUR,BEZEI From TVKVT

Where VKBUR NOT IN ('CT*');

Not applicable

Re: Where Condition in SAP

I tried both the syntax but it is not working giving error

Community Browser