topic Data correction in QlikView

Data correction

Tue, 15 May 2012 08:15:28 GMT

Hi,

I load data from excel file and there data in a column is like 001,002,003 but when i create straight table and send report to excel it shows 1,2,3 of this column vaues, please help me for this.

SRS

Data correction

Nicole-Smith — Tue, 15 May 2012 12:50:54 GMT

If all of the data in that column is supposed to have 3 digits, you could use the formula:

=num(Data, '000')

I hope that helps!

Data correction

kaushiknsolanki — Tue, 15 May 2012 12:54:48 GMT

Hi,

While loading the data use Text() function to keep the 0 as it is.

Like this.

Load Text(Field1) as Filed1 from ABC;

This will keep 001 as it is even if you export it to excel.

Regards,

Kaushik Solanki