topic Re: Operator DIFFERENT FROM in QlikView

Operator DIFFERENT FROM

Mon, 28 Apr 2014 10:22:44 GMT

Hi everyone!

i'm writing a formula where I need to use the operator "different from" (in excel is <>). I've tried the same in QV but it doesn't work...

I have

KPI_progetto={'VO01','VO03','VO02','VO99'}

instead I need to write:

KPI_progetto DIFFERENT FROM {'VO00'}

any suggestion???

THANK YOU!!!!

Re: Operator DIFFERENT FROM

bbi_mba_76 — Mon, 28 Apr 2014 10:26:08 GMT

Hi,

where are you writing the expression?

If it is a set analysis you could write -={'VO00'}

or use the match function

match(KPI_progetto,'VO00')=1

so if you need the <> try

match(KPI_progetto,'VO00')<1

Re: Operator DIFFERENT FROM

MK_QSL — Mon, 28 Apr 2014 10:33:24 GMT

Where NOT Match(KPI_progetto,'V000');

Re: Operator DIFFERENT FROM

Wed, 30 Apr 2014 09:26:29 GMT

thank you @Michele Barini! -={VO00} worked perfectly!

Re: Operator DIFFERENT FROM

Wed, 30 Apr 2014 09:28:54 GMT

Thank you @Manish Kachhia, but I think your suggestion must be applied within the script, while I was looking for something I could use in an expression.