topic Re: Where Condition in SAP in QlikView

Where Condition in SAP

Tue, 23 Jul 2013 12:37:37 GMT

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 ..

Tue, 23 Jul 2013 12:56:38 GMT

TRY THIS

Load * ;

SQL VKBUR,BEZEI From TVKVT

Where VKBUR != 'CT*';

Tue, 23 Jul 2013 13:42:13 GMT

Not working giving Error

Tue, 23 Jul 2013 13:48:26 GMT

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*');

Tue, 23 Jul 2013 14:01:37 GMT

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