topic Re: IF... in QlikView

IF...

Mon, 17 Feb 2014 17:30:49 GMT

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)

Re: IF...

MK_QSL — Mon, 17 Feb 2014 17:34:13 GMT

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

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

Re: IF...

Colin-Albert — Mon, 17 Feb 2014 17:35:19 GMT

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

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

Re: IF...

Mon, 17 Feb 2014 17:52:23 GMT

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

Re: IF...

Mon, 17 Feb 2014 18:44:58 GMT

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!,

Re: IF...

MK_QSL — Mon, 17 Feb 2014 18:47:28 GMT

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

Re: IF...

Mon, 17 Feb 2014 19:09:21 GMT

Manish,

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

Re: IF...

Colin-Albert — Mon, 17 Feb 2014 19:23:59 GMT

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