topic Re: Export dimension as numbers to Excel in a pivot table in QlikView

Export dimension as numbers to Excel in a pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello.

I have a pivot table and I wish to export my dimensions as numbers to excel... For example, i want my ID-dimension to be a Number in excel.

Right now all dimensions appears as "General" in Excel after the export.

I have no problems exporting the expressions, in the pivot table, as numbers, but it just wont work for the dimensions...

What are the neccesary requirements in order to get this to work?

Or is it not possible in Qlikview? Not first time I've had problems with exporting to excel in QV.

I have tried to set, in the easter egg options:

ExportFormat = 1

ExcelExportMixedAsTest = 1

In my loading script i'm using the num() function for the dimension field.

num(personId)

Also in the dimension tab, for the pivot table, i have tried to explicit type num(personId) for the dimension.

I have also set the field in Document Settings... -> Numbers -> personId to number format, with no avail...

Questions:

- Is it possible to export dimensions as numbers in excel

- If it is possible, what values has to be set?

Any help is appreciated, thanks!

Frank_Hartmann — Wed, 31 Oct 2018 12:48:32 GMT

can u share a sample qvw?

maheshkuttappa — Wed, 31 Oct 2018 14:45:53 GMT

change easter egg ExcelExportMixedAsTest = 0 it should work.

Anonymous — Wed, 31 Oct 2018 16:04:24 GMT

Thanks, but I've tried that and it dosen't work.

See picture below, it's still "general" format for the dimension. And I want it to be Excels Number format..

Any more ideas?