Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
pontus_agren
Contributor II
Contributor II

Export dimension as numbers to Excel in a pivot table

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!

3 Replies
Frank_Hartmann
Master II
Master II

can u share a sample qvw?

mahesh3k
Creator
Creator

change   easter egg ExcelExportMixedAsTest = 0 it should work.


Capture.PNG

pontus_agren
Contributor II
Contributor II
Author

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..

notnumberformatinexcel.PNG

Any more ideas?