How to force an pivot Excel Export to keep numbers as numbers?

[#1]

Hi there.

In a pivot table we have a dimension showing the Project_ID = 1001

And an expression calculating the Total Sales of the Project: Total Sales = 1001

Now when exporting this simple pivot table to Excel the Project_ID, which is a number in the pivot table, is formatted as text in the resulting Excel, but the Total Sales value is still a number.

Is it possible to force Qlikview to keep the dimension number format in an Excel export?

(Changing the number format of the field Project_ID in the document properties does not help, it seems).

[jjordaan]

Hi CapHF,

When you go to the help menu and then to about QlikView you can click with your right mous on the QlikView icon on the bottom left side.

Then you need to surch for the setting ExportFormat and set it 1.

Hope thus helps

[its_anandrjs]

Hi,

Yes this is right go to Help >> About Qlikview >> right click on the Qlik icon >> and provide this settings

Regards

Anand

[#4]

Hi Jeroen and Anand.

Thanks - but that setting is already in place as you can see down below. Any other ideas?

[#5]

Hi there.

I got it to work. Changing the Number Format Settings on the relevant field (Document Properties, Number) and removing a number formatting edition on the dimension did the trick.

Unfortunately we're facing another export problem. The expression in the pivot is formatted as: #,##0.00

- but it's exported as: #.##0,00 - the Thousand and Decimal separators are switched.

The field that is summed in the expression is set to #,##0.00 in the Number Format Settings.

How do one force Qlikview to keep the number formatting in an Excel export?

[#6]

Hi CapHF, I think your problem is related to System Variables, check that your system variables in QV match your system variables in OS (in windows you set that in Regional Settings).

Hope this helps

[#7]

Hi.

After talking to QV Support the conclusion was, that there is no good solution for this problem.

Changing the Easter Egg settings is not supported by Qlikview, and in our case it solved the first problem, but created a new one.

Another suggestion was to export to csv and the import to excel, but that's not a user friendly solution.

[#8]

hi CapHF,

we find solution in this link,

this issue is also for the web view

go to the end of this thread

https://community.qlik.com/thread/114512

and search Enable Easter Egg on QlikView Server

Cristiano