Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mohanrajsubrama
Not applicable

urgent

Hi Guys,

              I have a table like this and i dont want Customet No which starts from CU.How can i acheive this .i need help to get this solve .

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

  

FROM

(qvd)

where Customer_No!='C*';

thanks,

mohan

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: urgent

Hi,

Try this:

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

  

FROM

(qvd)

where left(No_,2)<>'CU';

5 Replies
Sokkorn
Not applicable

Re: urgent

Hi Mohan,

Try this:

where Not WildMatch(Customer_No,'C*');

Regards,

Sokkorn

er_mohit
Not applicable

Re: urgent

try like

where Customer_No<>'C*';

kaushik_solanki
Not applicable

Re: urgent

Try

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

  

FROM

(qvd)

     Where not(wildmatch(Customer_No,'CU*'));

Regards,

Kaushik Solanki

Not applicable

Re: urgent

Hi,

Try this:

Customer:

LOAD

     No_ as  [Customer No_],

     Name as [Customer Name],

     [Customer Disc_ Group],

     Channel as ChannelGroup,

     [Customer Type],

     [State Code],

     City as  CustomerCity,

  

FROM

(qvd)

where left(No_,2)<>'CU';

mohanrajsubrama
Not applicable

Re: urgent

Thanks for quick response Borja.

Regards,

Mohan.