Solved: Does not Equal?? - Qlik Community

Report Inappropriate Content · ‎2011-07-21

Hi All,

I am trying to exclude a serial number series starting with the code below. QV still says erro in epression...not sure why?

Thanks for helping the new guy out 🙂

=left(Machine_Serial_Number

,5) -= 80002)

derekjones · ‎2011-07-21

Hi Matthew

Couple of pointers...

To exclude (or include) you need to include an IF statement in your expression,
Does not equal sign for IF's is simply <> like in Excel. -= is only used in Set Analysis to differentiate from the {<>} closing the SA.

I've attached a simple example of excluding serial numbers. I've used a 5 digit serial and in my example I'm excluding those starting 4055..

Hope this helps

derekjones · ‎2011-07-21

Hi Matthew

Couple of pointers...

To exclude (or include) you need to include an IF statement in your expression,
Does not equal sign for IF's is simply <> like in Excel. -= is only used in Set Analysis to differentiate from the {<>} closing the SA.

I've attached a simple example of excluding serial numbers. I've used a 5 digit serial and in my example I'm excluding those starting 4055..

Hope this helps

rahulgupta · ‎2011-07-21

Hi,

Use this

=left(Machine_Serial_Number,5)<>80002

Regards

Report Inappropriate Content · ‎2011-07-21

Thanks Derek, appreciate the help.

Report Inappropriate Content · ‎2011-07-21

Cheers, thanks Rahul

Matthew Fourie

A6 - Performance & Operational Cost Engineer

Tetra Pak Packaging Solutions AB

Carton Bottle

Ruben Rausings Gata, SE 221 86 Lund, Sweden

Tel: +46 46 365961 Mob: +46 73 3365961

Matthew.fourie@tetrapak.com

www.tetrapak.com

This e-mail (including any attached documents) is intended for the named recipient(s) only. If you are not the

Intended recipient, we kindly ask you not to review, retain, copy or distribute this message, and we ask you to

notify the sender by reply e-mail immediately and delete this message from your system. Thank you.

Does not Equal??