Solved: Problem when exporting to excel numerical dimensio... - Qlik Community

Report Inappropriate Content · ‎2013-10-21

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!

patricio · ‎2013-10-21

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

View solution in original post

Gysbert_Wassenaar · ‎2013-10-21

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.

talk is cheap, supply exceeds demand

patricio · ‎2013-10-21

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

Report Inappropriate Content · ‎2013-10-21

I did that but it doesnt work..

patricio · ‎2013-10-21

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

Report Inappropriate Content · ‎2013-10-21

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

Report Inappropriate Content · ‎2013-10-21

thanks a lot!! it works!

grvandriessche · ‎2020-08-12

It does not work in 12.50

Problem when exporting to excel numerical dimensions