Export to excel

[abhaysingh]

when I am exporting data from CHART, the data is exporting in form of TEXT value.

I need Numeric VALUE in excel...

can any one help??

[its_anandrjs]

Hi,

You can use the NUM function for this can you provide sample excel file that is exported.

Regards,

Anand

[PrashantSangle]

Hi,

If num() will work for you.

If it wont work then

Go to Help Menu-> about Qlikview->right click on Qlikview Symbol->You will get setting window

in that

ExcelExportMixedAsText change its value to 0 from 1

Regards

[ashfaq_haseeb]

Hi,

Go to Settings -> User Preferences -> Export -> Number Formatting. Select Full Formatting.

Check if that helped

Qlikview sends to excel dimensions as text instead of num or date

Regards

ASHFAQ

[its_anandrjs]

For converting text to Number by exporting as excel do as Max suggested will be right way

Go to Help Menu-> about Qlikview->right click on Qlikview Symbol->You will get setting window

in that

ExcelExportMixedAsText change its value to 0 from 1

Regards,

Anand

[#6]

Go to Help Menu-> about Qlikview->right click on Qlikview Symbol->You will get setting window

in that

ExcelExportMixedAsText change its value to 0 from 1