topic Re: Convert Number to Text in QlikView

Convert Number to Text

Wed, 23 Mar 2011 16:51:34 GMT

In Need to convert a number to text without de decimal part.

When i try to convert with TEXT() function a number:

Text(IdUser)

i have this value 129.000000, i need only 129

any idea?

Thanks.

Re. :Convert Number to Text

martin59 — Wed, 23 Mar 2011 17:00:12 GMT

hi,

Have you tried something like this ?

text(round(IdUser,1))

Hope that helps you

Convert Number to Text

tresB — Wed, 23 Mar 2011 18:19:05 GMT

try this:

Text(Floor(IdUser))

Regards, tresesco

Re: Convert Number to Text

Fri, 04 Jan 2013 06:05:52 GMT

Hi,

Consider the example:

Data:

LOAD * INLINE
[
EmplNo,Amount
001,129.000
002,130.000
003,154.000
004,186.000
005,169.000
];

=text(round(Amount)) in your expression.

This should solve your problem.

Regards,

Snehal Nabar

Re: Convert Number to Text

SunilChauhan — Fri, 04 Jan 2013 09:09:19 GMT

Trim(' '&abs(Amount))

text(Trim(' '&abs(Amount)))

hope this helps

Re: Convert Number to Text

Fri, 04 Jan 2013 10:41:23 GMT

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

Re: Convert Number to Text

Fri, 04 Jan 2013 10:41:36 GMT

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

Re: Convert Number to Text

Fri, 04 Jan 2013 10:43:11 GMT

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

Re: Convert Number to Text

Fri, 04 Jan 2013 10:45:17 GMT

Try with this exp:

=text(left('IdUser',Index('IdUser','.')-1)) ;

Re: Convert Number to Text

Mon, 15 Apr 2013 13:27:01 GMT

Hi,

Please mark this post as answered, If it has solved your query.

Regards,

Snehal Nabar