Operator DIFFERENT FROM

[#1]

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

[bbi_mba_76 · Accepted solution]

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

[MK_QSL]

Where NOT Match(KPI_progetto,'V000');

[#4]

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

[#5]

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.