topic Re: Num format from CSV in QlikView

Num format from CSV

dseelam — Sun, 30 Jul 2017 16:31:39 GMT

Hello All,

Once I export data from CSV item_number appears wrong as shown in attached QVW

eg:

Item Number format should be eg : 3305

But its appearing as 000000000000003305

How to convert back as 3305

It's not single item_number all item_numbers looks weird

Please check attached QVW

Thanks,

tomasz_tru — Sun, 30 Jul 2017 17:27:26 GMT

When a string is too long it won't be converted to number. You can use evaluate function:

evaluate(ItemNumberField & '*1');

Tomasz

antoniotiman — Sun, 30 Jul 2017 17:33:09 GMT

Hi,

maybe

=Num(Right(ITEM_NUMBER,13))

Max nr QV digits is 14.

Regards,

Antonio

Nagaraju_KCS — Sun, 30 Jul 2017 18:36:49 GMT

Try this,

Replace(LTRIM(REPLACE(ITEM_NUMBER, '0', ' ')), ' ', '0') as ITEM_NUMBER;