topic Make sure that it is numeric values in QlikView

Make sure that it is numeric values

Tue, 02 Jul 2013 13:22:17 GMT

I have a simple question, but I need a simple command.

I have 2 different databases, and I have a field in both tables that are "Orders". The problem is that I'm not sure that they are both numeric.

What do I have to put in front of the field name to be sure ex: XXXX(Orders)?

I'm not even sure that it is the correct approach to the problem - can anybody help?

Best regards

Annette

Re: Make sure that it is numeric values

swuehl — Tue, 02 Jul 2013 13:25:05 GMT

num(Orders) should do what you want, it will format the number representation of your Orders field and return NULL if no number representation exists.

Re: Make sure that it is numeric values

Wed, 03 Jul 2013 08:26:54 GMT

Hi Swuehl

Thanks for your quick reply.

It was helpful...

Best regards

Annette