topic Re: Shopcode stored as text, need to be number in QlikView

Shopcode stored as text, need to be number

Fri, 13 Sep 2013 19:11:50 GMT

Hey guys, I have a field (Shopcode) that comes from Salesforce. The thing is that it comes stored as text, but i need it to be stored as a number, so it will be recognized as the same shopcode of my other database. how do I change that? I tryed 'num([Shop Code])', but it didn't work. Is there anyone who can tell me?

thank you

Re: Shopcode stored as text, need to be number

hic — Fri, 13 Sep 2013 19:16:01 GMT

Num#([Shop Code])

... but used with a proper format code.

HIC

Re: Shopcode stored as text, need to be number

Fri, 13 Sep 2013 19:18:30 GMT

Try using Text() function

Re: Shopcode stored as text, need to be number

CELAMBARASAN — Fri, 13 Sep 2013 19:43:20 GMT

Try with Num# function

if [Shop Code] is like '12345'

Num#([Shop Code])

if it has values like '123,456' Then use formatting

Num#([Shop Code], '#,###')