Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How format value to show zero at beginning of a value

Hi

How would I get data to show in the same format as the source data for values that begin with one or more zeros? for example:

invoice numbers, which are alpha numeric, when they start with 0 they are being shown as 2308 instead of 002308, i.e. the zeros at the beginnning are not showing.

How would I format the data to show these please?

I have tried the TEXT(VALUE) as VALUE option but this made no difference.

Thanks.

2 Replies
Greg_Williams
Employee
Employee

text(<your field>)

ashfaq_haseeb

Hi,

try below

LOAD

     Text(FIELD) as FIELD;

SQL SELECT

     FIELD

FROM DBTABLE;

Regards

ASHFAQ