Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Re: Qlikview converting Text to Number and removing leading zeros

Hi

Try like this

LOAD

     ...

     Text(Account_type) as Account_type;

SQL SELECT

     Account_type,

     ...

FROM DBTABLE;

Not applicable

Re: Qlikview converting Text to Number and removing leading zeros

Thanks everyone.

Have to say this was not straight forward and not straight way to handle it. Most of standard tools do keep in mind data type while selecting.

Thanks

Regards

Ravi

MVP
MVP

Re: Re: Qlikview converting Text to Number and removing leading zeros