topic Re: Does not Equal?? in QlikView

Does not Equal??

Thu, 21 Jul 2011 08:35:12 GMT

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 — Thu, 21 Jul 2011 08:45:39 GMT

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 — Thu, 21 Jul 2011 09:08:13 GMT

Hi,

Use this

=left(Machine_Serial_Number,5)<>80002

Regards

Thu, 21 Jul 2011 09:24:32 GMT

Thanks Derek, appreciate the help.

Thu, 21 Jul 2011 09:37:51 GMT

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.