topic Re: Distinguish from values in the same column in QlikView

Distinguish from values in the same column

Tue, 01 Sep 2015 16:01:01 GMT

Hello,

I was wondering if anyone knows how i can distinguish values in the same column that start with a letter.

For example i got orders that when are generated from source A they are just numbers, but when generated from source B they have 4 letters in the start. What i really want to do is a button that would only select the ones that are only numbers. I thought i could try to create a flag in the load script that could differenciate between a number and a string, but im not sure how to do this.

thanks for your help guys,

Re: Distinguish from values in the same column

lironbaram — Tue, 01 Sep 2015 16:05:31 GMT

you can use this function in the script

isnumber(OrderID) As Flag

it will return -1 for numbers and 0 to stirngs

Re: Distinguish from values in the same column

Tue, 01 Sep 2015 16:27:00 GMT

thanks i didnt know that function existed, thanks alot.

Just if anyone read this, the actual function is isNum(), but yeah thanks.