IF...

[#1]

Hola, necesito hacer algo simple, pero no se si lo estoy encarando bien..

Necesito contar los "servidores" cuyo nombre no contengan la palabra 'firewall'...

yo estoy intentando hacer algo asi pero no funciona...

Alguien tiene una mejor idea?

Gracias!!

if (Descripción <> '%Firewall%' then count(servidor), null)

[MK_QSL]

COUNT({$<Descripción  -= {'*Firewall*'}>}servidor)

or

COUNT({$<Descripción  -= {'Firewall'}>}servidor)

[Colin-Albert · Accepted solution]

I don't know Spanish, but this is how to do a "not like" comparison.

if (wildmatch(Descripción , '*Firewall*') =0 ,count(servidor))

[#4]

your answer was very helpful, I am beginner with qlikview!

[#5]

Excusme Albert

Can I ask you a more question?
How I can do the same as I did before but more fields ... for example ...
  if (wildmatch (Description, '* A *', '* B *', '* C *', '* D *', '* E *', '* F *', '* G *', '* H * ',' * I * ',' * J * ',' * K * ',' * L * ',' * M * ',' * N * '= 0, count (Server))
There will be another way to do this calculation? because it does not work ...
Thank you!,

[MK_QSL]

Use the same in my answer and let me know if it is working or not.

[#7]

Manish,

Doesn't work fine, because the result that show me is -1 in all cases....

[Colin-Albert]

Hi Daniela,

Your text has spaces before and after each letter, so is looking for data that does not match "* A *" or "* B *" .

Check for any extra spaces in your list.

If you want to test if the data does match the list, then change the test to if(wildmatch() =1, value)

Colin