Problem when exporting to excel numerical dimensions

[#1]

Hi,

When I export a pivot table to excel, my numeric dimensions are represented as text values.  I already set up the format of these fields in the document properties, and also i put them as calculated dimensions, but doesn't work at all. I am using Qlikview 11 SR3

Please help me!

[Gysbert_Wassenaar]

You can try copying the Full Table data using the Copy to Clipboard menu when you right click the chart. Or use a macro like explained here: http://community.qlik.com/message/99902#99902. Or maybe export to csv instead.

[patricio]

If your dimension is dim1 you can define num(dim1) as dim1 in your script

[#4]

I did that but it doesnt work..

[patricio · Accepted solution]

It works for me in 11.2 SR3

If I use the following script:

table:

LOAD
dim1 ,
num(dim2) as dim2 ,
value
;
LOAD * INLINE [
dim1, dim2, value
1, 1 , 1
2, 2 , 1
3, 3 , 1
];

I created a pivot table and dim1 is exported as text but dim2 is exporte as a number

[#6]

oh i thought you meant as a calculated dimension, let me try and I would let you know!

[#7]

thanks a lot!! it works!

[grvandriessche]

It does not work in 12.50