topic Re: Problem when exporting to excel numerical dimensions in QlikView

Problem when exporting to excel numerical dimensions

Mon, 21 Oct 2013 17:31:17 GMT

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!

Re: Problem when exporting to excel numerical dimensions

Gysbert_Wassenaar — Mon, 21 Oct 2013 18:15:58 GMT

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.

Re: Problem when exporting to excel numerical dimensions

patricio — Mon, 21 Oct 2013 18:58:54 GMT

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

Re: Problem when exporting to excel numerical dimensions

Mon, 21 Oct 2013 19:03:51 GMT

I did that but it doesnt work..

Re: Problem when exporting to excel numerical dimensions

patricio — Mon, 21 Oct 2013 19:16:29 GMT

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

Re: Problem when exporting to excel numerical dimensions

Mon, 21 Oct 2013 19:19:09 GMT

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

Re: Problem when exporting to excel numerical dimensions

Mon, 21 Oct 2013 19:29:21 GMT

thanks a lot!! it works!

Re: Problem when exporting to excel numerical dimensions

grvandriessche — Wed, 12 Aug 2020 12:20:14 GMT

It does not work in 12.50