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.

Not applicable

what is substitute Oracle's not like in formula

hi,

what I wanna do in formula is following.

if(CODE_A not like '0007*',amount)

Please anyone tell me this solution.

Regards,

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: what is substitute Oracle's not like in formula

try this

if(not(A like 1),1,0)

5 Replies
Not applicable

Re: what is substitute Oracle's not like in formula

use set analysis

ex:

sum( {$-<CODE_A ={'0007*'}>} amount)

Not applicable

Re: what is substitute Oracle's not like in formula

try this

if(not(A like 1),1,0)

Not applicable

Re: what is substitute Oracle's not like in formula

Great tip!

Just to complement

=if(not(Name like 'Barl*'), Name)

Esta mensagem (incluíndo qualquer anexo) é dirigida apenas para o uso do indivíduo ou da entidade a qual está endereçada e pode conter informações privadas, proprietárias, privilegiadas, confidenciais que podem servir como evidências sob as leis aplicáveis ou em processos judiciais.

Caso você não seja o destinatário pretendido, você está aqui notificado que qualquer uso, disseminação, distribuição, ou cópia dessa comunicação é estritamente proibida. Se você recebeu essa comunicação por engano, notifique-nos imediatamente por telefone, e destrua essa mensagem se estiver impressa ou (ii) exclua imediatamente essa mensagem se esta for uma comunicação eletrônica.

Obrigado.

This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product.

If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and destroy this message if this is printed or (ii) delete this message immediately if this is an electronic communication.

Thank you.

Re: what is substitute Oracle's not like in formula

Hi,

if(not CODE_A like '0007*',amount)

Not applicable

Re: what is substitute Oracle's not like in formula

hi all

thank you for your replay.

I will finaly use follwiong expression you said.

> if(not(CORD_A like '0007*'),amount)

but i guess all solution posted here may work fine.

Thanks!