topic Re: urgent in QlikView

urgent

mohanrajsubrama — Thu, 11 Jul 2013 10:21:34 GMT

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

Re: urgent

Sokkorn — Thu, 11 Jul 2013 10:22:43 GMT

Hi Mohan,

Try this:

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

Regards,

Sokkorn

Re: urgent

er_mohit — Thu, 11 Jul 2013 10:23:23 GMT

try like

where Customer_No<>'C*';

Re: urgent

kaushiknsolanki — Thu, 11 Jul 2013 10:23:31 GMT

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

Re: urgent

Thu, 11 Jul 2013 10:24:33 GMT

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

Re: urgent

mohanrajsubrama — Thu, 11 Jul 2013 11:22:10 GMT

Thanks for quick response Borja.

Regards,

Mohan.