Search string

[deepakqlikview_123]

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,

[deepakqlikview_123]

Hi

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

Thanks,

[SunilChauhan]

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

[jagan]

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.

[its_anandrjs]

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;

[SunilChauhan]

Great yaar

i will really appriciate your Idea

thanks