topic Re: Can I reformat fields in script? in QlikView

Can I reformat fields in script?

Wed, 21 Aug 2013 17:11:26 GMT

I'm working on my first report, which uses the same fields in several sheet items. The source data is an Excel sheet, and, although, I highlighted and formatted each column, many of the numerical fields are showing more digits after the decimal point than I'd like.

Example: data formatted as $1.2274 in data table is displayed as 1.2273189243510 in Qlikview.

I can reformat the fields within each sheet item's Properties, but I'd like to do it more efficiently (before loading the data). I've found instructions for reformatting dates but not for numbers or, possibly, text - is this possible?

Thanks in advance.

Re: Can I reformat fields in script?

tresB — Wed, 21 Aug 2013 17:28:38 GMT

You can try num() function. It allows formatting as well.

Re: Can I reformat fields in script?

Wed, 21 Aug 2013 18:01:52 GMT

I tried this, but it didn't work.

[Prev Field Name],

[Field Name] as num(#,0000),

[Post Field Name],

I googled a bit more and found num() used in an expression, but I can't do that in the script, can I?

Re: Can I reformat fields in script?

tresB — Wed, 21 Aug 2013 18:18:35 GMT

try like this:

Load

Num(PreField, '##.####') as NewField

Re: Can I reformat fields in script?

Wed, 21 Aug 2013 19:11:07 GMT

Thank you so much!

Too bad it doesn't apply to existing instances - but I'll redo my work and know for next time.

Edit. It is working in my straight table and list boxes, but not in my pivot tables.