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,

[anbu1984]

While loading use where condition like below

While [Dealer invoice code] <> 'DI99'

Type specific search substring in search box.

[deepakqlikview_123]

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

[SunilChauhan]

where

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

hope this helps

[its_anandrjs]

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

[jagan · Accepted solution]

Hi Deepak,

Try like this

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

Regards,

Jagan.

[its_anandrjs]

Do like in script

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

[SunilChauhan]

you can use

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

or

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

hope this helps

[SunilChauhan]

Hi

Can we use use like keyword in qlikview

i never found like keyword in qlikview.

Thanks

Sunil

[jagan]

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

Regards,

Jagan.