topic Re: Search string in QlikView

Search string

deepakqlikview_123 — Fri, 25 Apr 2014 04:19:56 GMT

Hello Team,

I want to exlude specific string in column where

Dealer invoice code is not equal to containing DI99 can you please tell me how to proceed.

Moreover also suggest how to serach string in search box containing specific substring.

Thanks,

Re: Search string

anbu1984 — Fri, 25 Apr 2014 04:40:18 GMT

While loading use where condition like below

While [Dealer invoice code] <> 'DI99'

Type specific search substring in search box.

Re: Search string

deepakqlikview_123 — Fri, 25 Apr 2014 04:57:15 GMT

Bu this is not working an you please suggest other way for doing same

Re: Search string

SunilChauhan — Fri, 25 Apr 2014 05:27:36 GMT

where

left(trim([Dealer Invoice code]),4)<>'D199';

hope this helps

Re: Search string

its_anandrjs — Fri, 25 Apr 2014 05:32:42 GMT

Can you provide any sample for the same may be easy.

Re: Search string

jagan — Fri, 25 Apr 2014 05:47:10 GMT

Hi Deepak,

Try like this

[Dealer invoice code] Not Like '*DI99*'

Regards,

Jagan.

Re: Search string

its_anandrjs — Fri, 25 Apr 2014 05:55:17 GMT

Do like in script

Where NOT WildMatch( [Dealer invoice code],'*DI99*' )

Re: Search string

SunilChauhan — Fri, 25 Apr 2014 05:55:48 GMT

you can use

wildmatch([Dealer invoice code],'*DI99*')=0

where not exists([Dealer invoice code],'DI99');

hope this helps

Re: Search string

SunilChauhan — Fri, 25 Apr 2014 07:28:05 GMT

Can we use use like keyword in qlikview

i never found like keyword in qlikview.

Thanks

Sunil

Re: Search string

jagan — Fri, 25 Apr 2014 07:30:32 GMT

Yes you can use, it is similar to LIKE in SQL.

Regards,

Jagan.

Re: Search string

deepakqlikview_123 — Fri, 25 Apr 2014 07:57:46 GMT

Can you please tell me, How where not exists will work in this case

Thanks,

Re: Re: Search string

SunilChauhan — Fri, 25 Apr 2014 09:13:00 GMT

Ya i know i thing it will work only while connecting to sql db and sql code in qlikview

but not for other sources

see the attched file

Re: Search string

jagan — Fri, 25 Apr 2014 09:28:43 GMT

Hi,

I will work for LOAD statement in WHERE condition also, and in IF() also you can use it.

LOAD

WHERE Salesman Like 'Mark*';

LOAD *

INLINE [

Salesman, Sales, Month

Mark, 10000, Jan

Chris, 20000, Jan

Mark Waugh, 15000, Feb

Chris, 10000, Mar

];

It is show error when using Not, if you are using Not then you have to use like this

LOAD

WHERE Not(Salesman Like 'Mark*');

LOAD *

INLINE [

Salesman, Sales, Month

Mark, 10000, Jan

Chris, 20000, Jan

Mark Waugh, 15000, Feb

Chris, 10000, Mar

];

Regards,

Jagan.

Re: Search string

its_anandrjs — Fri, 25 Apr 2014 09:42:09 GMT

You can try this way also

Tab1:

LOAD *

INLINE [

Salesman, Sales, Month

Mark, 10000, Jan

Chris, 20000, Jan

Mark Waugh, 15000, Feb

Chris, 10000, Mar

];

NoConcatenate

LOAD Salesman, Sales, Month

Resident Tab1

Where Not WildMatch(Salesman,'Mark*');

DROP Table Tab1;

Re: Search string

SunilChauhan — Fri, 25 Apr 2014 09:59:10 GMT

Great yaar

i will really appriciate your Idea

thanks