Number formatting in dimensions

[#1]

Hi everyone,

I've been struggling with some issues at the moment.

When i try to export a chart to excel, it shows numbers as text. There have been a lot of topics on that already. Very frustrating that this bug seems to not be fixed.

Usually, you could go around the bug by using the num() function in the dimension.

However, i'm running into the issue that when i do that, i get null values in that column. So that means i get empty cells in Excel.

Anyone got an idea how to fix that?

[#2]

The issue is not with the dimension, i believe. Just set your formating for the expression right from the Number tab.

RL

[Gysbert_Wassenaar]

Usually, you could go around the bug by using the num() function in the dimension.

However, i'm running into the issue that when i do that, i get null values in that column.

Then your number values are not numbers. Num() can format only numbers, not text. Use the Num#() function to create numbers from text values first.

[#4]

I have already set the number formatting in the document properties...

[#5]

I've just tried that, and it does fix the numbering issue.

What i've done:

- Change the document properties for number format

- Used num(num#(Dimension))

However; the export to excel still fails to see the column as a number.

[simenkg]

You set the system variabel "ExcelExportMixedAsText" to 0.

To do this in the Client go to: Help - About QlikView - right click the "Q" in the lower left corner - Scroll to ExcelExportMixedAsText and set the value to 0.

To do this on the server go to:

C:\ProgramData\QlikTech\QlikViewServer or C:\Documents and Settings\All    users\ApplicationData\QlikTech\QlikViewServer depending on OS)

Edit the Settings.ini file and add a line

ExcelExportMixedAsText = 0

Do this at your own risk, as changing these settings are not recommended by Qlik.

[#7]

Ran into that during my extensive search.

That setting is already set to 0, however, no resolution i'm afraid

Even multiplying the dimension by 1 or another number does not help.

[simenkg]

Try using rangesum around the expression. It defaults to 0.

[#9]

Tried Rangesum(num#(Dimension)), no luck.

[Gysbert_Wassenaar]

Can you post a small qlikview document that demonstrates the problem?