topic Re: Number and string in QlikView

Number and string

spividori — Wed, 12 Mar 2014 21:29:52 GMT

Hi.

I perform a query showing the client code from 2 different tables and throws me the following result:

I need that the second value to be as the first. How I can solve it?

Regards.

Re: Number and string

Wed, 12 Mar 2014 21:36:07 GMT

If you are only looking to change the way it is displayed, go to Chart Properties > Presentation > Alignment and set both text and numbers to the right.

Re: Number and string

Anonymous — Wed, 12 Mar 2014 21:44:21 GMT

num(evaluate(ClaveCrm))

Re: Number and string

Clever_Anjos — Wed, 12 Mar 2014 21:48:26 GMT

Use num#() transformation while load your data

Example:

LOAD

num#(trim(ClaveCrm)) as ClaveCrm;

SQL SELECT

ClaveCrm

from your table

Re: Number and string

maxgro — Wed, 12 Mar 2014 21:51:12 GMT

text(ClaveCrm) to left align

num(ClaveCrm)

Re: Number and string

spividori — Thu, 13 Mar 2014 11:59:06 GMT

HI.

Thanks for replying. I solved it by changing the settings of a ThousandSep and DecimalSep and it worked..

SET ThousandSep=','; SET DecimalSep='.';