topic Re: Export to numeric expression to excel with more precision than displayed in QlikView

Export to numeric expression to excel with more precision than displayed

Wed, 08 Jun 2011 22:52:41 GMT

I have a numeric expression in a straight table that is formatted as money, displayed with zero decimal places.

Is there a way to export this straight table to Excel with the full numeric precision of the underlying data? (Right now, the value of this expression column when exported to Excel is limited to the displayed precision.)

Re: Export to numeric expression to excel with more precision than displayed

Anonymous — Wed, 08 Jun 2011 22:58:52 GMT

Hey,

It should be possible with the use of Dual() to have one presentation value and one export value.

Please see the attached example where the last expression in the straight table uses Dual(). When I export it to Excel it shows the full decimal value. (More about Dual() in the F1-help).

Re: Export to numeric expression to excel with more precision than displayed

Wed, 08 Jun 2011 23:13:31 GMT

Wow, this is very cool. Thank you! I didn't realize you could use dual() in an expression. The documentation seems to imply that it is valid only in the load script.

Also, the straight table is smart enough to treat the expression as numeric in the Visual Cues tab, so that highlighting by value still works. Perfect.