topic Re: Store value as Num in QlikView

Store value as Num

Anonymous — Fri, 28 Feb 2014 07:00:32 GMT

Hi Community

I have account no as below, how to make the account no '979987980000000' become a number, all the account no aligned to the right?

Re: Store value as Num

MK_QSL — Fri, 28 Feb 2014 07:11:13 GMT

QlikView supports a maximum of 14 digits in your number. If it is longer than that, it will be interpreted a a text.

First, you can use evaluate() to convert your original text into a integer.Then, you can use NUM to format it appropriately

Try Below

num( EVALUATE(YourFieldName),'#0') AS YourFieldName

Re: Store value as Num

er_mohit — Fri, 28 Feb 2014 07:17:15 GMT

Try this

Evaluate(AccountNo) as N,

Re: Store value as Num

hic — Fri, 28 Feb 2014 07:26:29 GMT

But if it is an account number, it would be better to treat it as a unique key instead of as a number. I would instead remove the numeric interpretation by wrapping it in the Text() function:

Text(AccountNo) as AccountNo

HIC

Re: Store value as Num

jagan — Fri, 28 Feb 2014 07:26:33 GMT

Hi,

Try Num(), otherwise you can align all the values to the right by changing

Properties -> Presentation -> Alignment -> Text and Numbers to Right

Hope this helps you.

Regards,

Jagan.

Re: Store value as Num

sunilkumarqv — Fri, 28 Feb 2014 07:30:03 GMT

Hi SurynnChin,

Its easy on presentation tab make alignment as right .

Hope i got your solution

Re: Store value as Num

Anonymous — Fri, 28 Feb 2014 11:59:41 GMT

Can you elaborate more? Is there any advantage to store the account number as a text instead of num?

Re: Store value as Num

Fri, 28 Feb 2014 12:05:35 GMT

try this

since NumFormat has capacity to display 14 digit number. more than 14 digit number show in text.

for this use it.

Evaluate(AccountNo) as AccountNo_new

Re: Store value as Num

hic — Fri, 28 Feb 2014 12:13:03 GMT

I assume that AccountNo is an ID that you will use only as a key or selection field, and that you will never make any arithmetic calculations with it. If so, there are no longer any major advantages with having it as a number. (Except that a number takes less space in RAM than a string.)

Further, you have an account number that cannot be represented exactly as a number. You can use Evaluate() to assign a numeric value to it, but you will lose information. For instance, the following two account numbers will be assigned the same numeric value:

979987980000000000

979987980000000001

So, the advantage with storing it as text, is that you don't lose any information: The two account numbers above will still be two separate account numbers.

HIC

Re: Store value as Num

ashwanin — Fri, 28 Feb 2014 12:35:33 GMT

use text(AccountNo) as AccountNo

Re: Store value as Num

Anonymous — Fri, 28 Feb 2014 12:46:53 GMT

Thanks for your explanation. I never knew that i will lose information if i store it as a number.