topic Export to excel in QlikView

Export to excel

abhaysingh — Wed, 22 Oct 2014 09:50:24 GMT

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 — Wed, 22 Oct 2014 09:56:15 GMT

Hi,

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

Regards,

Anand

PrashantSangle — Wed, 22 Oct 2014 10:08:54 GMT

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 — Wed, 22 Oct 2014 10:09:57 GMT

Hi,

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

Check if that helped

Regards

ASHFAQ

its_anandrjs — Wed, 22 Oct 2014 10:15:02 GMT

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

Wed, 22 Oct 2014 10:22:19 GMT

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