Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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