Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Shopcode stored as text, need to be number

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Shopcode stored as text, need to be number

Num#([Shop Code])

... but used with a proper format code.

HIC

3 Replies
Employee
Employee

Re: Shopcode stored as text, need to be number

Num#([Shop Code])

... but used with a proper format code.

HIC

Not applicable

Re: Shopcode stored as text, need to be number

Try using Text() function

Re: Shopcode stored as text, need to be number

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], '#,###')

Community Browser