topic Re: Format Number Question in QlikView

Format Number Question

Wed, 03 Jun 2015 15:17:04 GMT

Hello - I'm unable to format a number in to the this layout: 05-14-2015

The below format is not working '##,##,####' as it displays the value as : 05,14,2015

Can anyone help?

NUM(SUM({<PI_ID={'DATE'}>} VALUE), '##,##,####'),

swuehl — Wed, 03 Jun 2015 15:33:53 GMT

Try,

NUM(SUM({<PI_ID={'DATE'}>} VALUE), '##-##-####','.','-'),

Wed, 03 Jun 2015 15:51:48 GMT

Hi that didn't work

swuehl — Wed, 03 Jun 2015 15:59:03 GMT

Seems to work for me. If you want a leading zero:

=NUM( 5142015, '00-00-0000','.','-')

Wed, 03 Jun 2015 16:08:05 GMT

I see now it is working. thank you!