Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Operator DIFFERENT FROM

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Operator DIFFERENT FROM

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

View solution in original post

4 Replies
Partner
Partner

Re: Operator DIFFERENT FROM

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

View solution in original post

MVP
MVP

Re: Operator DIFFERENT FROM

Where NOT Match(KPI_progetto,'V000');

Not applicable

Re: Operator DIFFERENT FROM

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

Not applicable

Re: Operator DIFFERENT FROM

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.